Automatic Count
 

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

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

"fran55" wrote in message
...
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