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

suppose you have a list of months in the 3rd row, then:

=SUM(INDIRECT(C3&"!C4")

change C3 appropriately


On 23 Mar, 22:35, STS wrote:
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

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.

"STS" wrote:

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