How to set up worksheet where cells change monthly
Maybe you could use a SUMIF function instead, using date as the
criteria, but that depends on what exactly you are trying to do.
Hope this helps.
Pete
On Nov 10, 5:11*pm, Robina wrote:
I have an excel spreadsheet where each month the cell location changes - i.e.
*SUM(C56:C79) = January is changed to SUM(C57:C79) in February. Each month it
increments down. I have to repeat this formula 120 times, with each one a
different *amount. Is there any way to code this into Excel so that I don't
need to change each cell every month?
|