Subtotal

[Guest]

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

 

[Celt]

Could you not add a column to your data to indicate which quarter each
month falls into, then do another subtotal on that? It would be really
hard to use a formula (I think) as any sort of SUM formula will include
the "hidden" cells containing monthly activity.

 

[Guest]

Thanks, this works just fine, i was wondering if there might be an easier way
as i wouldn't need to do all the math to the first record and then copy the
format/formulas to the rest of the sheet. Thanks again.

Paul

 

[Gerald]

Have you considered using a pivot table?