Count Rows When Using Auto-Filter

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

Nick

Using the auto-filter function I need to count the number
of rows returned each time I select a new value. I can do
a COUNTA (–1 to allow for the header row), on the column
that counts all the rows but when I use the filter I still
get the total count not a count of the reduced quantity by
the filter.
Can anyone help?
Nick
 
use the subtotal function with a first argument of 3

=subtotal(3,A2:A300)

as an example.

Make sure the column you do the counta on will have values in all rows.
 
Back
Top