SUMPRODUCT

Returns the sum of the products of the values in the specified arrays.

Syntax

SUMPRODUCT( ReferenceOrArray array1, [ReferenceOrArray array2], ... ) → Number

Parameters

array1
array2
…

One or more arrays or cell references to include in the calculation.

Remarks

All parameters shall have the same dimensions. Otherwise, the function will return the #VALUE! error value. SUMPRODUCT treats entries that are not numeric as if they were zeros.

Example

Formula

=SUMPRODUCT(A1:B4,C1:D4)

See Also

Function Reference