Please enable JavaScript to view the comments powered by Disqus.


Validating multiple criteria with SUMPRODUCT function

The sumproduct is an array formula that can validate multiple criteria and the resulting array of TRUE and FALSE can be converted to 1s and 0s and then summed up to give final count. 

Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


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

Lets chat on this