Thanks:  0
Likes:  0

1. I've got in column A a series of names, ex. A1="Fred", A2="Jos", A3="John" and so on. In column B next to the names I've got a value, B1=236.69, B2=254.87, B3=326.99,...

Here's my problem, the names in column A may repeat themselves. I need a way to match the names in Column A to the values in column B and find the total value that is in column B that matches with the specific name in column A.

Here's an example:

I've got 3 instances of "Mark" in column A with corresponding values in column B of 10.00, 5.00 and 15.00. At the bottom of my sheet I've got to show that Mark has a total of 30.

Can anyone help?

2. On 2002-04-26 06:36, imonline wrote:
I've got in column A a series of names, ex. A1="Fred", A2="Jos", A3="John" and so on. In column B next to the names I've got a value, B1=236.69, B2=254.87, B3=326.99,...

Here's my problem, the names in column A may repeat themselves. I need a way to match the names in Column A to the values in column B and find the total value that is in column B that matches with the specific name in column A.

Here's an example:

I've got 3 instances of "Mark" in column A with corresponding values in column B of 10.00, 5.00 and 15.00. At the bottom of my sheet I've got to show that Mark has a total of 30.

Can anyone help?
=SUMIF(A1:A100,"Mark",B1:100)

If "Mark" in a cell, say, E1, use E1 in lieu of "Mark" in the above formula.

Sometimes I have a tendancy to look for a complicated solution (lookup, hlookup,...).

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•