# SUMIF vs SUMIFS in Excel

> SUMIF adds the values that meet one condition; SUMIFS handles several.

Source: https://spreadsheetpractice.com/functions/compare/sumif-vs-sumifs · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

SUMIF adds the values that meet one condition; SUMIFS handles several. The catch is the argument order: SUMIF puts the range to add last, SUMIFS puts it first. Pick one habit, usually SUMIFS, and the order stops tripping you up.

## The differences

|  | SUMIF | SUMIFS |
|---|---|---|
| Conditions | One | One or more, all must be true |
| Argument order | range, criteria, sum_range | sum_range, criteria_range1, criteria1, … |
| When sum_range is left out | Adds the criteria range itself | sum_range is required |
| Available in | Every version | Every version |

## Same data, side by side

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=SUMIF(A2:A7,"West",C2:C7)` | $2,850 | SUMIF: condition range first, sum range last |
| F3 | `=SUMIFS(C2:C7,A2:A7,"West")` | $2,850 | SUMIFS: sum range first, same answer |
| F4 | `=SUMIFS(C2:C7,A2:A7,"West",B2:B7,"Online")` | $1,910 | Add a second condition: West and online |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Region | Channel | Sales |  | Question | Result |
| 2 | West | Online | $1,200 |  | West sales | $2,850 |
| 3 | East | Store | $860 |  | West sales (SUMIFS) | $2,850 |
| 4 | West | Store | $940 |  | West online sales | $1,910 |
| 5 | East | Online | $1,530 |  |  |  |
| 6 | West | Online | $710 |  |  |  |
| 7 | North | Store | $480 |  |  |  |

## When to use each

### Choose SUMIF when

There is exactly one condition and you're matching an existing workbook that already uses it.

### Choose SUMIFS when

Anything else. It handles one condition just as well and you won't have to rewrite it when a second one appears.

## The functions

- [SUMIF](https://spreadsheetpractice.com/functions/sumif): SUMIF adds up values for the rows that meet one condition: total travel expenses, revenue for one product, every invoice over $500. Every current version.
- [SUMIFS](https://spreadsheetpractice.com/functions/sumifs): SUMIFS adds the values where every condition is true: East region widget sales, February revenue, large orders from one customer. Every current version.

## Questions

### Why does my SUMIF return 0?

Usually the criteria don't match exactly (an extra space, or numbers stored as text), or the sum range is in the wrong argument position.

### Can SUMIFS sum with OR conditions?

Not in one call. Add two SUMIFS together, one per alternative.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
