| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sum year to date tables
I want to sum revenue's depending on the datespecified in a Cell (for example
A1= march-07). I have the full year plan on a separate sheet. I want to be able to specify the month and the answer come back with the sum of the month up to that date. I have a separate sheet with the plan for the year "year plan". the first row is the date jan-07 feb 07 mar-07..ect) the second row is the revenue figures for that month plan. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| holiday dates | Excel Worksheet Functions | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| List First Friday's Date of the year | Excel Discussion (Misc queries) | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
