Forum Discussion
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 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))
