Please enable JavaScript to view the comments powered by Disqus.


Using sumproduct to validate for multiple criteria.

This formula checks for the given criteria, then this process continues and we get an array of the TRUE and FALSE that multiplies with 1 to get the fina lresult.

Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


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

Lets chat on this