I've tried several methods of doing this simply but nothing is working for me. I've tried variations on vlookup, lookup, match and offset.
Here's the problem:
I've got one row of names. There are 12 - 14 names, but they are repeated in different cells, making the row in one workbook 300 - 400 names long, and in another workbook, 400+ names. The next row over is a cell containing dollar values.
I need to write a simple formula that looks for one name in the row of names, then finds all occurrences of it. Next, it will look at the next row over to see the dollar value associated with that name, then add all dollar values up.
For instance:
A B
1 Anderson $10.00
2 Best $5.00
3 Anderson $7.50
4 Smith $8.16
5 Anderson $15.00
6 Best $4.56
7 Anderson $10.00
I need the formula to look in row A and find all occurrences of "Anderson". For each occurrence it needs to look in row B and find the corresponding dollar amount, then add all of them together.
In this case, the formula would return $42.50 for "Anderson"
Any help?
Here's the problem:
I've got one row of names. There are 12 - 14 names, but they are repeated in different cells, making the row in one workbook 300 - 400 names long, and in another workbook, 400+ names. The next row over is a cell containing dollar values.
I need to write a simple formula that looks for one name in the row of names, then finds all occurrences of it. Next, it will look at the next row over to see the dollar value associated with that name, then add all dollar values up.
For instance:
A B
1 Anderson $10.00
2 Best $5.00
3 Anderson $7.50
4 Smith $8.16
5 Anderson $15.00
6 Best $4.56
7 Anderson $10.00
I need the formula to look in row A and find all occurrences of "Anderson". For each occurrence it needs to look in row B and find the corresponding dollar amount, then add all of them together.
In this case, the formula would return $42.50 for "Anderson"
Any help?
Last edited:
