Thread: Display count of filtered rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Display count of filtered rows
=SUBTOTAL(3,A2:A100)


"Eric" wrote:

I think I recall that at one time Excel used to automatically display a count
of the number of rows resulting from a filter, in the Excel status bar at the
bottom of the screen. However, it does not do that for me now.

Is my recollection wrong, or is there an option that I need to turn on?

Thanks.
Reply With QuoteReply With Quote