Why not use the subtotals feature instead? That's what it's for. :)
http://www.officearticles.com/excel/...soft_excel.htm
You can choose COUNT instead of SUM.
************
Anne Troy
www.OfficeArticles.com
"kkrebs" wrote in message
...
I would like to know if there is a way to count the cells in a filtered
list.
I have a spreadsheet that has 107 rows that has salespersonnel associated
to
some rows. What I want to do is filter the list by the salespersonnel and
then count how many rows are shown.
Thank you!
Kim