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!