Forum Discussion
Solved
Sum of All Product?
Hi, How do I get the total of all apples in the below table in one simple formula? Product QTY Product QTY Product QTY Apple 1 Apple 1 Apple 7 Apple 2 Apple 1 Apple 2 ...
Qinnab You could use SUMIF as demonstrated in the attached file. It's not very elegant though and perhaps your real life situation isn't as simplistic as your example suggests.
Array methods will perform calculation using your data as it stands, but is better with Excel 365. The first approach works with legacy Excel
= SUMIFS(QtyTable, ProductTable, ProductList)where the quantity table is simply the product table offset one cell to the right.