=SUMIF(A:A,"John Doe",B:B)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Ltat42a" wrote in
message ...

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