I have a list of names in Column A and a amount of money owed in
column B. This list is deep in another part of a lager sheet and can
not be sorted. The problem is there are names that repeat in column A
and I need a arrive at a sum for whom owes what for each person.

I am looking for help creating a function that will look at the range,
identify the Values associated with the names next to them, and add
them up.

For example: look for the first, second and third instance of "Bob" in
column A and add up the numerical values in the Column B next to each
instance of "Bob".

Thanks so much..

I think that you mean

=SUMIF(A:A,A2,B:B)


--
__________________________________
HTH

Bob

wrote in message
...
I have a list of names in Column A and a amount of money owed in
column B. This list is deep in another part of a lager sheet and can
not be sorted. The problem is there are names that repeat in column A
and I need a arrive at a sum for whom owes what for each person.

I am looking for help creating a function that will look at the range,
identify the Values associated with the names next to them, and add
them up.

For example: look for the first, second and third instance of "Bob" in
column A and add up the numerical values in the Column B next to each
instance of "Bob".

Thanks so much..