If you turn on the filter and make the filter active (that is, make a
selection from one of the filtered columns), the autosum button will use the
subtotal function rather than sum. If you want to enter it yourself, the
formula is =subtotal(9,range), where range is the entire (unfiltered) range;
subtotal will exclude cells that get filtered out by your autofilter
selections.

"ttbbgg" wrote:

Working with a large spreadsheet. I will engage Autofilter and want to add a
section at the bottom for subtotals pertaining to the filtered data shown.
What formula(s) would I use for that since it would change for each filter
selection?

Also, I want to put in a dynamic count for an array, however there will be
duplicates. How do I eliminate a count with dupes in an array?