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.


The Countryman wrote:

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.

--
Yorkie

--

Dave Peterson