Forum Discussion
mckenzie gordon
Dec 02, 2017Copper Contributor
Sumif Formula problems
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 h...
Willy Lau
Dec 02, 2017Iron Contributor
=SUMPRODUCT(($A$1:$A$9=61093433229)*($B$1:$B$9))