Count Rows When Using Auto-Filter

Giganews Newsgroups
Subject: Count Rows When Using Auto-Filter
Posted by:  Nick (n…@westnet.com.au)
Date: Mon, 6 Oct 2003

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

Replies