keep total formulas / rows when apply filter
Hi,
When I filter a column in my table, the totals / formulas at the bottom don't adjust for the filter. EXAMPLE, Column A has data that is either male or female with all columns thereafter totaled at the bottom. If I set the filter to view only the female data, all of the other column totals go away. How do i make it keep the total formulas at the bottom for just the filtered data? THank you! |
keep total formulas / rows when apply filter
First, make sure your aultofilter is setup to filter only your data, not
everything. (Select area, then apply filter) Second, check out the SUBTOTAL function. You can do most of the basic math functions with it, and it ignores filtered data. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mandy" wrote: Hi, When I filter a column in my table, the totals / formulas at the bottom don't adjust for the filter. EXAMPLE, Column A has data that is either male or female with all columns thereafter totaled at the bottom. If I set the filter to view only the female data, all of the other column totals go away. How do i make it keep the total formulas at the bottom for just the filtered data? THank you! |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com