Using VLOOKUPs and calculating total.

[Lmaonade]

Hi guys,

I'm not great with these Vlookups, how do I set a vlookup to add up any matches?

For example my data table has:

	A	B
1	10001	846
2	10001	454
3	10002	662
4	10002	277
5	10002	548
6	10003	292
7	10004	367
8	10004	269

<tbody>
</tbody>

So when I do my Vlookup by the reference numbers (10001, 10002 etc) I want the result to give me for each 10001 = 1300, 10002 = 1487, 10003 = 292, 10004 = 636

How would I set this?

Thanks,
Andy

 

[Lmaonade]

I'm probably being very silly here, is it better to actually use a SUMIF?

 

[JazzSP8]

No silly at all, SUMIF is exactly the way to go from the sound if it;

=SUMIF(A:A,10001,B:B)

OR

=SUMIF(A:A,A1,B:B)

If you wanted to use cell references to make it more dynamic

 

[Lmaonade]

Thank you very much Jazz, worked perfectly.