Adding up values corresponding with repeating names

D

db_murray

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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a big matrix in Word 2013 5
Merging from an Excel file with graphics 1
retrieving values from a certain column 2
Look up one value and return multiple corresponding values 5
Lookup based on matrix values 2
Adding Problem 6
Return MAX value from column B and Name from column A 3
Finding Corresponding Cell Value 2

Top