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.