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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"dallyup2" wrote in message
...
I am trying to add name in a colum. ie., 4 Mikes, 3 Toms, 8 Diane. Is
there a
way to do this?

Thanks