Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal
I have a large spreadsheet with 12 columns and 2400 rows. I use a filter to
bring up one account that shows me sales for each month, each month is on a separate row so the filtered results have twelve rows of data. I then subtotal the results which add up the twelve months of data, per column. The question, how can I now use the results shown to add up just the 1st quarter results, not the twelve rows of data? This needs to work after I select any customer. Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
subtotal nesting errors new this month | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |