Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count with Auto-Filter On | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Count items with auto-filter | Excel Discussion (Misc queries) | |||
Count Auto-filter results | Excel Discussion (Misc queries) |