Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do some cells automatically switch to ####### when I write? | New Users to Excel | |||
Automatically insert time in excel but not automatically updated | Excel Worksheet Functions | |||
how do I write an IF/other statement to cut off time data? | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions |