ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtotals in Excel 2003 with Autofilter and Grouping (https://www.excelbanter.com/excel-discussion-misc-queries/120578-subtotals-excel-2003-autofilter-grouping.html)

[email protected]

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



All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com