Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display rolling months
I have two problems. First, I need to be able to view 9 months worth of data
in column format and then total the 9 months. The nine months that are displayed and totalled is dependant on a user defined date. E.G. the user puts in October 2009. The columns that should be displayed and summed are Oct '09 through Jun '10. The second problem is that the columns from multiple worksheets need to be totalled on a separate worksheet. For instance, the first month will always be in the second column, but will not necessarily be in column B. How do I get a formula to calculate sums from the specific columns that are currently displayed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help with a formula for rolling twelve months | Excel Discussion (Misc queries) | |||
ROLLING 12 MONTHS PLEASE HELP ME!!!!! | Excel Discussion (Misc queries) | |||
rolling 12 months | Excel Worksheet Functions | |||
rolling months | Excel Discussion (Misc queries) | |||
Problem with formula: need rolling average of 10 months | Excel Programming |