Returns the sum of the products of the values in the specified arrays.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=SUMPRODUCT(A1:B4,C1:D4) |
See Also
Function Reference