how to edit formula without changing formula of each cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sadat - 24 Apr 2007 10:42 GMT

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.

Reply to this Message

Rodrigo Ferreira - 24 Apr 2007 11:24 GMT

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

Signature

Rodrigo Ferreira

> Hello,
> My problem is: I use a very large
[quoted text clipped - 6 lines]
> very
> much thankful if anyone can help me with this problem.

Reply to this Message

Duke Carey - 24 Apr 2007 14:02 GMT

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.

> Hello,
> My problem is: I use a very large
[quoted text clipped - 3 lines]
> every cell without selecting each cell and editing manually? I would be very
> much thankful if anyone can help me with this problem.

Reply to this Message