Automatic Count

[Guest]

How do I get a record count afer I filter a column in Excel? Example: I have
a list of 100 names and I filter out those who prefer phone contact versus
e-mail countact. How do I get a count (a number) without manually counting
each record that appears after the filter?

Thank you,
Frances

 

[Paul B]

Frances, have a look at subtotals in help, something like this should work,
=SUBTOTAL(3,A2:A20)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003