Please HELP!

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

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.
 
No, but subtotal does perform many summary functions.

Regards,
Tom Ogilvy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal Formatting 2
Subtotal function 2
Subtotal by VBA 5
Issue with nested data subtotals 3
Subtotals 2
subtotal question 1
Subtotal macro in each worksheet 13
Excel Subtotals 2

Back
Top