| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 week calculations
I am trying to establish a 12 week rolling sum of cells on multiple
worksheets (1st qtr, 2nd, 3rd, & 4th) that will display on a Summary worksheet. I am thinking this , On the Summary sheet I have a =today cell, which will correspond to a column heading. I want it to calculate the past 12 weeks from the date "Today", which may span 2 worksheets. My brain is not working right at the moment, so any ideas would be appreciated. If more info is required, please reply and I will fill in the blanks. Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a rolling 12 week graph | Charts and Charting in Excel | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
| Calculation using rolling 4 week amounts | Excel Discussion (Misc queries) | |||
| user defined function | Excel Worksheet Functions | |||
Threaded Mode
