=SUBTOTAL(3,G2:G20)

--
HTH

Bob Phillips

"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