Counting a Filtered List

K

kkrebs

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
 
K

kkrebs

Thank you very much for your help. You have just made my life alot easier.
I was not aware of this feature.

Kim
 
P

petevang

One way to do it would be go ahead and filter the data on one worksheet,
then copy your filtered data to a new worksheet. Once you copy to a new
worksheet you should be able to view your data the way you want it.
 
T

tkaplan

if data is in col a rows 2 through 108 and salespersonnel is in col B:

put this formula in any cell:
=COUNTIF(B2:B108,"=Sam Brown")

You can exchange Same Brown with the name you are looking for.

hth
 
Top