How do I count different names in a colum ie: 4 mikes 3 toms

D

dallyup2

I am trying to add name in a colum. ie., 4 Mikes, 3 Toms, 8 Diane. Is there a
way to do this?

Thanks
 
M

Max

One way

Assume data is in A1 down, e.g.:

Mike T
Diane P
Tom P
Mike P
Tom J
Mike L
Diane M
etc

List the names in say, C1:C3 : Mike, Diane, Tom

Put in D1:
=SUMPRODUCT(--(ISNUMBER(SEARCH(C1,A1:A100))))
Copy down

Col D will return the required counts
 
M

Max

As described, I had assumed that the cells in col A would contain more stuff
(e.g. other text) than just the names: Mike, Diane, Tom
 
M

Max

Oops, sorry .. Just realized that I had missed out
fixing the arbitrary range A1:A100

The formula in D1 should be:
=SUMPRODUCT(--(ISNUMBER(SEARCH(C1,$A$1:$A$100))))
Copy D1 down

Adjust the range A1:A100 to suit ..
 
Top