SUMIFS
Math & TrigSUMIFS helps you perform mathematical and trigonometric calculations for everyday analysis workflows.
Overview
Start with "=" then enter SUMIFS(sum_range, criteria_range1, criteria1, ...). Keep argument order as shown and use cell ranges where appropriate.
Backend scalar pathComplete docs
Syntax & Arity
=SUMIFS(sum_range, criteria_range1, criteria1, ...)
3+ arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| sum_range | Required | Single | Range of values to sum. |
| criteria_range1 | Required | Single | Range evaluated against a condition. |
| criteria1 | Required | Single | Condition used to include matching values. |
Example Inputs & Outputs
Formula
=SUMIFS(B1:B10,A1:A10,">=5")
Example Output
120
Sums values where one or more criteria are matched.