SUMPRODUCT
Returns the sum of products of corresponding elements in one or more arrays.
| Category | Aggregate |
| Syntax | SUMPRODUCT(array1, [array2], ...) |
Parameters
| Parameter | Required | Description |
|---|---|---|
array1 | Required | The first range or array to multiply then sum. |
array2 | Optional | Additional ranges or arrays (must be same size as array1). |
Example
SUMPRODUCT(range, criteria)
Auto-generated from the EngCanvas function registry.