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