Summing with identical Vlookup values

K

kanuvas

Hi all,

I am having a issue with Vlookup. I have a table with a number of
values which im looking up in a column but a lot of them are the same.
I need a formula that can add the ones that are the same and print the
value into a cell.

Instance-

value i want to look up : bbb

Item Number#
aaa 5
aaa 3
bbb 4
ccc 8
aaa 4
ccc 7
bbb 8

So i want to to lookup bbb and add all instances together to give me :
12

Any help would be appreciated, thx a lot.
 
G

Guest

Hi,
Use SUMIF function:

Assume Item Number is in column A (a2:a8) and counts in B (b2:b8) then in C1
put "=SUMIF(a2:a8,"bbb",b2:b8)" (without quotation marks).

HTH
 

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

Find All Instances of a Value 1
Adding numbers in a range 3
String separated with commas 5
VBA Conditional formating for specific text in several columns 1
Lookup and store in array 1
Can I use vlookup to do this? 4
VBA, copy lines with specific value 3
Formula require for complex lookup 4

Top