The SumProduct() function returns the sum of the products of corresponding ranges or arrays. The default operation is multiplication, but addition, subtraction, and division are also possible.

Examples

SUMPRODUCT((B2:B7==B10$) * (C2:C7==C10$) * (D2:D7))
SUMPRODUCT(A1:A5, B6:B10, C11:C15)