=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.