I need to copy a formula from column I to column J, and would like to do the
following:
Column I Column J
=SUM((APR!C4)) =SUM((MAY!C4))
Basically, when I copy I would like to add 1 month, but leave the cell (C4)
the same. When I try it, the month always stays the sam, but the cell changed
from C4 to D4. I would like to know how to copy the above forumula in Colum I
so the result will be the formula above in Column J.
Thank you for any help.
Simon
Jarek Kujawa - 23 Mar 2008 22:56 GMT
suppose you have a list of months in the 3rd row, then:
=SUM(INDIRECT(C3&"!C4")
change C3 appropriately
> I need to copy a formula from column I to column J, and would like to do the
> following:
[quoted text clipped - 8 lines]
> Thank you for any help.
> Simon
art - 24 Mar 2008 14:55 GMT
when you enter C4 you have to press the F4 button so it should become $C$4
This way it won't move when you drag.
> I need to copy a formula from column I to column J, and would like to do the
> following:
[quoted text clipped - 8 lines]
> Thank you for any help.
> Simon