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 tre...