Adding totals after filtering

T

The Countryman

Is it possible to atomatically have rows added up after a filtering process
has been applied? I can apply a sum function but this adds up entries which
are and are not displayed after the filtering. I only want the selected
entries to be added up automatically.
 
D

Dave Peterson

I like to use Row 1 for the subtotals. Row 2 contains the headers and rows
3-xxx will contain the actual data.

Then I can use something like:
=subtotal(9,a3:a999)

=subtotal() ignores rows hidden by data|filter|autofilter.
 
G

Gord Dibben

=SUBTOTAL(9,A:A)

Or a cell range instead of A:A.............A1:A523


Gord Dibben MS Excel MVP
 
Top