SUMPRODUCT(...)
Validating multiple criteria with SUMPRODUCT function
Used Functions
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
Practice SUMPRODUCT Formula at Sheetzoom
SUMPRODUCT formula at Microsoft help
0
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.