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

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.


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=536463

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

"Celt" wrote:


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.


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=536463

Have you considered using a pivot table?