Please enable JavaScript to view the comments powered by Disqus.


Using SUMPRODUCT function with multiple criteria.

The formula works by checking for multiple criteria step wise and then the resulting arrays are multiplied with each other and then sum is done by using SUMPRODUCT().

Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


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

Lets chat on this