Board index » Excel » how to edit formula without changing formula of each cell

Excel129
Hello,

My problem is: I use a very large

formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and the

formula is used in more than 1000 cells. but the month name and range changes

according to row and column of every cell. How can I change the formula of

every cell without selecting each cell and editing manually? I would be very

much thankful if anyone can help me with this problem.


-

If you want to replace only "2007Jan", select only the cells you want and

Find/Replace



--



Rodrigo Ferreira





"sadat" <sadat@discussions.microsoft.com>escreveu na mensagem



-

change your formula to



=SUMPRODUCT(--(month(F13:F59)=month#)--(year(F13:F59)=year#),J13:J59)



You can put the month# and year# values in cells and change the formula

above to reference the cells, not specifice vlues.







"sadat" wrote: