SumProduct
[this page | pdf]
Function Description
Returns the sum of the product of two series, i.e. if the
elements of the first array are 
and
the elements of the second array are 
(for
)
then returns 
where
Provided for compatibility with the SUMPRODUCT function in
Microsoft Excel and some other spreadsheet systems.
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: Double
| Parameter Name | Variable Type | Description |
| x | Double() | First set of values |
| y | Double() | Second set of values |
Links to:
-
Interactively run function
-
Interactive instructions
-
Example calculation
-
Output type / Parameter details
-
Illustrative spreadsheet
-
Other Calculator-type functions
-
Computation units used
Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement