| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count items with auto-filter
I have a sheet with a cell which counts the lines: ="Count "&COUNT(F6:F32).
When I use the auto filter the number of lines counted remains the same. Is there a way to only count the lines which are visible by the auto filter? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count items with auto-filter
="Count "&SUBTOTAL(2,F6:F32)
-- Regards, Peo Sjoblom "Joe M." wrote in message ... I have a sheet with a cell which counts the lines: ="Count "&COUNT(F6:F32). When I use the auto filter the number of lines counted remains the same. Is there a way to only count the lines which are visible by the auto filter? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| Count Auto-filter results | Excel Discussion (Misc queries) | |||
| Counting items in auto filter - how? | Excel Discussion (Misc queries) | |||
| How do I filter for items that end in % | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Linear Mode
