Sumif Formula problems

Copper Contributor

Im trying to add together quantities of products I have duplicates of using UPCs

i.e the table below I want to be able to sum together all the duplicates on the left, 610934033229=37

can anyone help me?

610934033038 6
610934033229 25
610934033229 12
610934033243 23
610934033243 25
610934033243 25
610934033243 25
610934033250 12
610934033274

25

1 Reply
=SUMPRODUCT(($A$1:$A$9=61093433229)*($B$1:$B$9))