Please HELP!
 

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.

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.