SUMPRODUCT(...)
Using SUMPRODUCT() to sum product wise sales.
Used Functions
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
Practice SUMPRODUCT Formula at Sheetzoom
SUMPRODUCT formula at Microsoft help
0
The formula validates if the lookup range has the same product as the one we want to sum, the corresponding sales figure in the column B is added to give the final answer.