Thread: How do I count rows in a filtered list when using AutoFilter?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chiefcook
 
Posts: n/a
Default How do I count rows in a filtered list when using AutoFilter?
I have a database list in Excel spreadsheet and use the AutoFilter to look at
selected items. How can I count the number of rows with data that are
displayed when the worksheet is filtered, similar to SUBTOTAL does when a
column has numbers in it?
Reply With QuoteReply With Quote