How about pivot table on the original data. That can sum.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wonderdogs828"
wrote in message
news:wonderdogs828.212wdb_1136325001.7768@excelfor um-nospam.com...

I did a subtotal function. I was in trouble of extracting just those
cells containing subtotals without copying those detailed cells.

How can I have a pure "subtotal" only worksheet?

Thank you.


--
wonderdogs828
------------------------------------------------------------------------
wonderdogs828's Profile:
http://www.excelforum.com/member.php...o&userid=30086
View this thread: http://www.excelforum.com/showthread...hreadid=497703