Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...$B$3:$B$13=$A20)*(...$C$3:$C$13=B$19)*1)

Using Sumproduct to check for multiple criterias

The Sumproduct function can validate multiple criteria and the final count is measured and summed up by the function to give the answer.


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

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

Lets chat on this