Sum Lookup



I'm wanting to lookup up one value in a list of other values and return the
sum of the values in the column next to it but can't figure out how.

For example, I have a list of items in column N. I want the sum from column
H each time the item in Column N appears in Column G. So basically anytime
the item in Column N appears in Column G, I want it to sum each value in
Column H in the corresponding (same row that the data appeared in in column G

Column G Column H
Allen 45
ABA 113
A&B 75
A&B 65
A&B 235
Accu 117
Accu 85
Ahaus 10

Say I have A&B in column N (I'm working in column O)....I want to know the
sum for A& it should return 375.

Any help?



Adjust the ranges in columns G and H as required and copy down this formula
in column O


I assume your values start in row 2 so in O2 enter

Copy formula down

change the range to fit your needs but remember the range has to be exactly
the same in both sides of the formula


You could try this in O1:


then copy down to cover the items you have in column N.

Hope this helps.


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

Help needed 0
SUM - IF - AND 7
Sum Total 2
Sum / Lookup 9
How to sum values between dates 4
PT Sum of Difference 2
Scrabble Value calculation for Welsh words 0