| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF? week, month & year-to-date totals
Hi - How do I do a YTD total? I have weekly data on a separate sheet, was
able to figure out weekly and then month-to-date running totals (using SUM) on the "main" sheet, but I don't know how to do a YTD. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF? week, month & year-to-date totals
Why not just sum the monthly totals? If that doesn't help, we'll need more
information on your data layout. Regards, Fred. "FSFGgirl" wrote in message ... Hi - How do I do a YTD total? I have weekly data on a separate sheet, was able to figure out weekly and then month-to-date running totals (using SUM) on the "main" sheet, but I don't know how to do a YTD. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum year to date totals for particular month | Excel Worksheet Functions | |||
| how to insert month date year and day of week | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | New Users to Excel | |||
| how to insert month date year and day of week | Excel Worksheet Functions | |||
| Week/month/year rollovers with PivotTable | Excel Worksheet Functions | |||
Linear Mode
