WorksheetFunction.SumProduct Method (Excel)
Multiplies corresponding components in the given arrays, and returns the sum of those products.
Syntax
식 .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)
식 A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 - Arg30 |
필수 |
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.