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

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

Thanks

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

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

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

One way is to use a pivot table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

In article ,
"dallyup2" wrote:

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

Thanks

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

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

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 ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--