| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I write a function that automatically changes over time
Another one
=SUM(A1:OFFSET(A1,MONTH(TODAY())-1,0)) The above will give a sum of A1:A5 and will keep on changing wrt month. If this post helps click Yes --------------- Jacob Skaria "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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I write a function that automatically changes over time
=SUM(A1:INDEX(A:A,MONTH(TODAY())))
"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? |
| Reply |
| 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 | |||
Linear Mode
