Please enable JavaScript to view the comments powered by Disqus.


Using SUMPRODUCT to sum against various criteria

The formula validates the result againt the given criteria and thens sum up the corresponding value.

Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


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

Lets chat on this