Subtotals in Excel 2003 with Autofilter and Grouping
 

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

Subtotals in Excel 2003 with Autofilter and Grouping
 

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.

bb wrote:

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

--

Dave Peterson

Subtotals in Excel 2003 with Autofilter and Grouping
 

Can you think of any other way to accomplish both filters and grouping?

Subtotals in Excel 2003 with Autofilter and Grouping
 

I haven't.

bb wrote:

Can you think of any other way to accomplish both filters and grouping?

--

Dave Peterson