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