Cooool. :)
************
Anne Troy
www.OfficeArticles.com
"kkrebs" wrote in message
...
Thank you very much for your help. You have just made my life alot
easier.
I was not aware of this feature.
Kim
"Anne Troy" wrote:
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