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:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10001[/TD]
[TD]846[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10001[/TD]
[TD]454[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10002[/TD]
[TD]662[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10002[/TD]
[TD]277[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]10002[/TD]
[TD]548[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10003[/TD]
[TD]292[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]10004[/TD]
[TD]367[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10004[/TD]
[TD]269[/TD]
[/TR]
</tbody>[/TABLE]


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.