SUMPRODUCT
Math & TrigSUMPRODUCT helps you perform mathematical and trigonometric calculations for everyday analysis workflows.
Overview
Start with "=" then enter SUMPRODUCT(array1, [array2], ...). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=SUMPRODUCT(array1, [array2], ...)
1+ arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| array1 | Required | Single | Array or range input. |
| array2 | Optional | Single | Array or range input. |
Example Inputs & Outputs
Formula
=SUMPRODUCT(<array1>, <array2>)
Example Output
Numeric result
Replace placeholders with your worksheet values or ranges to compute a result.