Please enable JavaScript to view the comments powered by Disqus.


Using SUMPRODUCT() to sum product wise sales.

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. 

Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


SUMPRODUCT(array1, [array2], [array3], ...)

Lets chat on this