Count Rows When Using Auto-Filter

[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

 

[Tom Ogilvy]

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.