Count Result of Auto Filter

[Nick]

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

Regards
Nick

 

[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.

 

[Debra Dalgleish]

Or you could just omit the header row from the range:

SUBTOTAL(3,A2:A100)