Yes, I will need a *unique* list of names. I will have about 20-27
persons in this list. In the column to the right of each name is a
number (representig hours). Each of the persons listed will have
multiple entries in this list. The results that I'm looking for is
"who" has "how many hours". If John Doe is in the list 50 times, each
time he is listed, he has 2 hours. My result will be "John Doe" =
100hrs. This will repeat for each person in the list.

Does this help??

Thanx


Ragdyer Wrote:
Since you say that the list is extensive, you could simply return the
total
along side *every* name on the list, so that you'll have duplicate
data, but
you wouldn't need to create a separate list of names, and you'll be
sure to
display the totals for all names in the list.

=Sumif($A$1:$A$1000,A1,$B$1:$B$1000)

And copy down.

If you *need* to create a *unique* list of all names, with the totals
along
side, post back.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------

"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



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