SUMIF
Math & TrigSUMIF helps you perform mathematical and trigonometric calculations for everyday analysis workflows.
Overview
Start with "=" then enter SUMIF(range, criteria, [sum_range]). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=SUMIF(range, criteria, [sum_range])
2 to 3 arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| range | Required | Single | Cell range used as function input. |
| criteria | Required | Single | Condition used to include matching values. |
| sum_range | Optional | Single | Range of values to sum. |
Example Inputs & Outputs
Formula
=SUMIF(<range>, <criteria>, <sum_range>)
Example Output
Numeric result
Replace placeholders with your worksheet values or ranges to compute a result.