On Mon, 20 Mar 2006 15:16:28 -0800, Taylor
wrote:
I am using Excel 2003 to manage a Club list and would like an automatic
number count of the names on my list both before and after using various
Filter functions.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...et.f unctions
Before is just
=COUNTA(A10:A20)
After is
=SUBTOTAL(2,A10:A20)
where A10:A20 is the column range which includes all the rows of your
data.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________