can I write a function that automatically changes over time
Something like:
=SUM(INDIRECT("A1:A"&MONTH(TODAY())))
will provide the monthly adjustment on the range of the sum.
--
Gary''s Student - gsnu200852
"andyp" wrote:
I would like to create a function that changes every month. For example in
month 1 the formula would be SUM(A1:A1), in month 2 it would be SUM(A1:A2),
in month 3 SUM(A1:A3), etc...
there is data in all cells starting at the first month, so I cannot just sum
the column.
Any suggestions?
|