excelSUMPRODUCT function


Introduction

The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products

Syntax

  • SUMPRODUCT(array1, [array2], [array3], ...)

Remarks

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