SUM
Math & TrigSUM helps you perform mathematical and trigonometric calculations for everyday analysis workflows.
Overview
Start with "=" then enter SUM(number1, [number2], ...). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=SUM(number1, [number2], ...)
1+ arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| number1 | Required | Single | Numeric input value. |
| number2 | Optional | Single | Numeric input value. |
Example Inputs & Outputs
Formula
=SUM(A1:A5)
Example Output
42
Adds all numeric values in the selected range.