SUMIFS
Adds the cells in a range that meet multiple criteria.
Math & TrigonometryMath BasicsMost Used
What it does
Adds cells that meet multiple conditions.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Arguments
sum_range(range) — Cells to sum.criteria_range1(range) — First range to evaluate.criteria1(criteria) — First condition.
Examples
Sum with 2 conditions
Sum Amount where Category="Food" and Region="EU".
FORMULA
=SUMIFS(C2:C6,A2:A6,"Food",B2:B6,"EU")
RESULT
25
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Category | Region | Amount |
| 2 | Food | EU | 10 |
| 3 | Food | US | 7 |
| 4 | Travel | EU | 5 |
| 5 | Food | EU | 15 |
| 6 | Other | EU | 3 |