WorksheetFunction.SumProduct Method
| Excel Developer Reference |
Multiplies corresponding components in the given arrays, and returns the sum of those products.
Syntax
expression.SumProduct(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 - Arg30 | Required | Variant | Array1, array2, array3, ... - 2 to 30 arrays whose components you want to multiply and then add. |
Return Value
Double
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.
See Also