Math & Trig
Modern
SUMIFS
Adds the cells that meet multiple conditions.
Available in All versions (Excel 2007+)
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, ...)What it returns
The sum of the cells matching all criteria.
Arguments
| Argument | Required | Description |
|---|---|---|
sum_range |
Yes | The cells to add. |
criteria_range1 |
Yes | The first range to test. |
criteria1 |
Yes | The condition applied to criteria_range1. |
… |
No | Add criteria_range/criteria pairs as needed (up to 127). |
Example
Criteria
City = "Paris" AND Amount > 100
| A | B | |
|---|---|---|
| 1 | City | Amount |
| 2 | Paris | 120 |
| 3 | Lyon | 200 |
| 4 | Paris | 200 |
| 5 | Paris | 90 |
Total
320
Sum only rows meeting every criterion: Paris and over 100 (120 + 200). Paris/90 is excluded.
=SUMIFS(C2:C100, A2:A100, "Paris", B2:B100, ">100")Important to know
sum_range comes FIRST — the reverse of SUMIF.
All ranges must be the same size.
Conditions are combined with AND (all must match).