SUMIF
Adds the cells specified by a given criteria.
Math & TrigonometryBeginner EssentialsMath BasicsMost Used
What it does
Adds cells that meet a single condition.
Syntax
SUMIF(range, criteria, [sum_range])
Arguments
range(range) — Cells to evaluate against criteria.criteria(criteria) — Condition (e.g., ">100", "Apples").sum_range(range) — Cells to sum (optional; defaults to range).
Examples
Sum by category
Sum Amount where Category is "Food".
FORMULA
=SUMIF(A2:A6,"Food",B2:B6)
RESULT
32
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Category | Amount |
| 2 | Food | 12 |
| 3 | Travel | 8 |
| 4 | Food | 20 |
| 5 | Other | 5 |
| 6 | Food | 0 |