how to edit formula without changing formula of each cell
 

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.

how to edit formula without changing formula of each cell
 

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

--

Rodrigo Ferreira


"sadat" escreveu na mensagem
...
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.

how to edit formula without changing formula of each cell
 

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:

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.