Auto filter count
 

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.

Auto filter count
 

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.
--
Best Regards,

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


"Mike Busch" wrote:

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.

Auto filter count
 

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.

Auto filter count
 

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.