![]() |
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