I am using 2000 so can't test this, but starting with 2003 (I believe) you
can also filter hidden rows not hidden by filtering by adding to whatever
number you are using in the subtotal formula. i.e.
=SUBTOTAL(9,range)
would become
=SUBTOTAL(109,range)

--
Kevin Vaughn


"Duke Carey" wrote:

If the data is hidden by virtue of a filtering operation, rather than simply
hiding the rows, you can substitute

=SUBTOTAL(9,range)

for

=SUM(range)

The SUBTOTAL() fucntion will ignore rows that the filter hides

"wolfthrone" wrote:

How do I omit hidden data from autosum calculations?