Thread: How do I count rows in a filtered list when using AutoFilter?
View Single Post
  #3  
Old December 22nd, 2005, 02:06 PM posted to microsoft.public.excel.worksheet.functions
bpeltzer
external usenet poster
  
Posts: n/a
Default How do I count rows in a filtered list when using AutoFilter?
If your filtered data (absent the header row) is in G2:G5, for example, then
=SUBTOTAL(3,G2:G5) will count the number of non-blanks in those cells which
passed the filter.

"chiefcook" wrote:

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?