Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to apply filter based on list or combo box?? | Excel Discussion (Misc queries) | |||
Can you apply the auto filter to data that are filtered? | Excel Worksheet Functions | |||
How can I count data after I apply a Filter in MS Excel | Excel Worksheet Functions | |||
How can I insert a row and have the existing formulas apply? | Excel Discussion (Misc queries) | |||
How do you apply Names in formulas? | Excel Discussion (Misc queries) |