Count Result of Auto Filter

N

Nick

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

Regards
Nick
 
N

Norman Jones

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.
 

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 with Auto-Filter On 5
Count Rows When Using Auto-Filter 1
Count items with auto-filter 1
Why don't my filter results always appear on the bottom left? 1
Count function in Auto-Filtered data 1
Auto Filter 3
Auto filter count 3
Macro - hide rows that are 0 without an auto-filter 3

Top