SUMPRODUCT of Function - Ms. Office Excel 2013

Sumproduct of Function - Ms. Office Excel 2013

SUMPRODUCT is meaning multiplies corresponding components in the given arrays, and returns the sum of those products.

Syntax:

=SUMPRODUCT(array1;array2;........;array255)

Remarks:

Array is fill numeric as arguments must have same dimension. when one dimension is zero, the SUMPRODUCT will be return to #Value! error.

AHS