View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Govind
 
Posts: n/a
Default subtotal question?

Hi,

Whats the formula you used. For picking up only subtotals, use

=SUBTOTAL(9,RANGE)

Regards

Govind.


wonderdogs828 wrote:

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.