Thread: Please HELP!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Please HELP!

No, but subtotal does perform many summary functions.

Regards,
Tom Ogilvy

LC wrote in message
...
In excel, the subtotal function ignores all other subtotal
functions.

Is there a way for the subtotal function to ignore other
function/formulas like sumproduct, sum, product, etc. ?

This is what I'm using:

Range(nrowcol).Activate
ActiveCell.Range(nrowcol).Select
Selection.subtotal GroupBy:=groups, Function:=xlSum, _
TotalList:=varr, Replace:=False, PageBreaks:=False, _
SummaryBelowData:=True

Thank you.