Hi

The Subtotal function does ignore all rows that are hidden by Autofilter,
but not rows that are manually hidden.
In XL2003 onward, you can get Subtotal to ignore all hidden rows (manual and
autofiltered) by placing 100 in from of the Subtotal argument, e.g.
=SUBTOTAL(109,A1:A100)
=SUBTOTAL(103,A1:A100

--
Regards
Roger Govier



"Jimbob" wrote in message
...
I think I may have worded that wrong. When looking at the subtotal
funtion,
I find that it still seems to count items that are filtered out using
autofilter. Is there a way not to count the items that are filtered out
by
autofilter?

"Wigi" wrote:

Hi

Have a look at the SUBTOTAL function.

In particular, pay attention to which argument you should use.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Jimbob" wrote:

I am trying to set up a log, of sorts that will allow me to keep
running
totals. I need this to take the numbers out as the rows are hidden
(upon
completion of the task). Is this a possiblity through any normal excel
functions, or is this something that will require a macro? I am
running
excel 2003.

Thanks,