WorksheetFunction.SumProduct Method (Excel)
Office 2013
Published: July 16, 2012
Multiplies corresponding components in the given arrays, and returns the sum of those products.
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
