Can I use Vlookup to sum same reference number

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