SUMIF vs SUMIFS
SUMIF adds with one condition; SUMIFS takes several, and the sum range comes first.
| SUMIF | SUMIFS | |
|---|---|---|
| Conditions | One | Up to 127 |
| Sum range | Third argument (optional) | First argument |
| Logic between conditions | — | All must be met (AND) |
Syntax and example
SUMIF
=SUMIF(range, criteria, [sum_range])
=SUMIF($A$2:$A$10,D2,$B$2:$B$10)
Adds only the rows that meet a condition.
SUMIFS
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
=SUMIFS(D2:D11,B2:B11,G2,C2:C11,G3)
Adds only the rows that meet every condition.
Which one to use?
SUMIFS also works with a single condition, so many people always use it to avoid mixing up argument order.
About Ads
This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.
Ads help us keep WebHerramientas free for everyone
Practice it
Solve the exercise on the sheet; it is checked instantly. See all lessons · Formula translator
SUMIFS
SUMIFS adds with several conditions. Unlike SUMIF, the sum range comes first: SUMIFS(sum_range, range1, criteria1, range2, criteria2…).
In G4, add up the amounts for the region in G2 and the product in G3. Use those cells as criteria rather than typing the text.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Salesperson | Region | Product | Amount | ||||
| 2 | Carmen | North | Laptop | 18,500 | Region | North | ||
| 3 | Jorge | South | Monitor | 4,200 | Product | Laptop | ||
| 4 | Lucía | North | Monitor | 3,900 | Total | |||
| 5 | Andrés | Central | Laptop | 21,000 | ||||
| 6 | Paola | South | Laptop | 17,800 | ||||
| 7 | Carmen | North | Tablet | 6,400 | ||||
| 8 | Jorge | Central | Tablet | 5,900 | ||||
| 9 | Lucía | North | Laptop | 19,900 | ||||
| 10 | Andrés | South | Monitor | 800 | ||||
| 11 | Paola | Central | Monitor | 4,600 | ||||
| 12 |
Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.
Frequently asked questions
- What is the difference between SUMIF and SUMIFS?
- SUMIF adds with one condition; SUMIFS takes several, and the sum range comes first.
- When should I use SUMIF or SUMIFS?
- SUMIFS also works with a single condition, so many people always use it to avoid mixing up argument order.