keep total formulas / rows when apply filter

[mandy]

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!

 

[Luke M]

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.