The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products
- SUMPRODUCT(array1, [array2], [array3], ...)
- The array arguments must have the same dimensions. If they do not, SUMPRODUCT returns the #VALUE! error value.
- SUMPRODUCT treats array entries that are not numeric as if they were zeros.