ExcelBanter - Count items with auto-filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count items with auto-filter (https://www.excelbanter.com/excel-discussion-misc-queries/146168-count-items-auto-filter.html)

Joe M.

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.

Peo Sjoblom

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.

All times are GMT +1. The time now is 02:13 AM.