Auto filter count

[Mike Busch]

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.

 

[Luke M]

Haven't figured out a formula yet, one possible work-around

Select a column of filtered data
In your status bar, right click on the box in the bottom-right corner that
usually displays a sum (2 boxes left of where the "Num" is displayed if num
lock is turned on)
Change this to count.

Its frustrating me that XL obviously can figure out here not to count
filtered data, yet doesn't provide a clear way formula-wise to do this. I
hope someone else can come up with a better solution. I too eagerly look
forward to seeing a solution.

 

[Fred Smith]

Use Subtotal rather than Count, as in:

=subtotal(2,d2:d1283)

Regards,
Fred.

 

[Luke M]

Need to use the counta function of SUBTOTAL, actually.
=SUBTOTAL(3,D21283)

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