SUMPRODUCT
Category: Mathematical Function.
Description: Returns the sum of the products of the corresponding values in two or more supplied arrays.
Syntax: SUMPRODUCT(array1, array2, array3, …)
The array arguments must have the same dimensions.
Array entries that are not numeric are treated as if they were zeros.