Thread: can I write a function that automatically changes over time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andyp andyp is offline
external usenet poster
  
Posts: 2
Default can I write a function that automatically changes over time
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?
Reply With QuoteReply With Quote