Count Result of Auto Filter

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I would like to count the number of rows returned when the
auto filter function is used.

Regards
Nick
 
Hi Nick,

You could use the Subtotal worksheet function, e.g.:

# FilteredRows = SUBTOTAL(3,A1:A100)-1

where 3 specifies the CountA function, A1:A100 represents the first column
in the autofilter range and the -1 adjusts for the header row.
 
Or you could just omit the header row from the range:

SUBTOTAL(3,A2:A100)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count function in Auto-Filtered data 1
Count with Auto-Filter On 5
Count items with auto-filter 1
Count Rows When Using Auto-Filter 1
Return value from the top of an auto filer list. 1
Why don't my filter results always appear on the bottom left? 1
Auto filter for multiple columns 2
Auto filter count 3

Back
Top