| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rolling 12 data
Hi I am trying to track a rolling 1 year cycle of data and am using this
:=SUMIF(A:A,"="&TODAY()-364,M:M), but if you falsely add data above todays date for instance if i went to 03/07/07 and inputted data it computes also I tried taking the greater than out but that doesnt work any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
