View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe M. Joe M. is offline
external usenet poster
 
Posts: 97
Default 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.