Can I use Vlookup to sum same reference number

[lekku]

I am working on a data with a range of same customer number but different sales figure.

If there any way I can search for a duplicate cusomer number and then summing up the sales? I tried to use vlookup but it only recognise the first reference number.

I have attached the excel for your reference.

Please help. Thanks in advance.


Regards

lekku

[jasoncw]

Try SUMPRODUCT. Use in F2 and copy down:

=SUMPRODUCT(('2009 total Sales'!$A$2:$A$1076=B2)*('2009 total Sales'!$B$2:$B$1076))

HTH,
Jason

[Paul]

Hi Lekku, welcome to the forum.

Try:

=SUMIF('2009 total Sales'!A:A,B2,'2009 total Sales'!B:B)

[lekku]

Thanks alot for all your help. It works.