Adding totals after filtering
 

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

Adding totals after filtering
 

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

Adding totals after filtering
 

=SUBTOTAL(9,A:A)

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


Gord Dibben MS Excel MVP

On Mon, 5 Mar 2007 07:59:39 -0800, 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.