Need to use the counta function of SUBTOTAL, actually.
=SUBTOTAL(3,D2:D1283)

But yea, looks like subtotal ignores filtered rows. =)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Fred Smith" wrote:

Use Subtotal rather than Count, as in:

=subtotal(2,d2:d1283)

Regards,
Fred.

"Mike Busch" wrote in message
...
I am using the autofiler in a worksheet. One I have the filter in use, I
would like to count the number of entries of that particular filter. I am
using =counta(d2:d23). This will give me the whole count for that column
without the filter, is there away of getting the count from just that
filter.
Exp. there are 1283 devices total, I filter only 128; I need to know that
count, when I use the above formula I come up with all 1283. Thanks in
advance.