Have you ruled out Pivot Tables?
A Pivot Table would automatically list each unique name and present the
total values for each name.

Is that something you'd be interested in?
***********
Regards,
Ron

XL2002, WinXP


"Ltat42a" wrote:


Hi All, Can Excel count data that is in two columns? Example, I have a
column of people's names. In the next column, I have a number.

Column A Coulmn B
John Doe 10
Jane Doe 8
Mary Doe 8
John Doe 8
John Doe 8

What I'm looking for is a way to count the number of "John Doe's" and
the number to the right of his name. Then the same for Mary Doe, Jane
Doe, etc...etc...etc...

In the end, I'll have John Doe 26, Jane Doe 8, Mary Doe 8,
etc...etc...

This listing will be extensive - several hundred rows long.
I'm trying to summarize each instance of John Doe & all his numbers and
so forth with everyone's name that is in the list.

Is this possible??

Thanx.


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=546477