Subtotals in Excel 2003 with Autofilter and Grouping

B

bb

Is there a way to use subtotals where the subtotal ignores filtered
rows but includes the grouped rows? It is interesting that when you
collapse the group the subtotal includes the rows but if you filter
first and then collapse the group the subtotal ignores both the
filtered rows and the grouped rows.

thanks
 
D

Dave Peterson

Not that I know.

After I first saw this, I decided that I'd always use one or the other--but not
both. It made it easier since I didn't have to explain the problem to the
manager types <vbg>.
 

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

Copying from Subtotal Data 2
Recalculating Subtotals 2
Sorting and subtotal in a filtered list 1
subtotals and sorts 1
Grouping Rows in Excel 2007 2
Subtotals Nightmare in Excel 2003 4
grouping rows 1
Subtotals Don't Collapse Correctly 1

Top