BeginnerTotals and maths
Syntax
=SUMIF(range, criteria, [sum_range])| Argument | What it means |
|---|---|
range | The cells to test against the condition. |
criteria | The condition, such as "Pen" or ">100". |
sum_range | The numbers to add. If you leave it out, the tested range itself is added. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Office supplies sales (fictional)
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Qty | Unit price | Region | Date |
| 2 | Pen | 10 | 1.5 | North | 2025-01-15 |
| 3 | Notebook | 5 | 12 | South | 2025-02-03 |
| 4 | Pen | 20 | 1.5 | South | 2025-02-28 |
| 5 | Stapler | 2 | 40 | North | 2025-03-10 |
| 6 | Folder | 15 | 3.25 | East | 2025-03-22 |
| 7 | Notebook | 8 | 12 | East | 2025-04-05 |
| 8 | Pen | 12 | 1.5 | North | 2025-04-18 |
| 9 | Marker | 30 | 2 | South | 2025-05-02 |
=SUMIF(A2:A9,"Pen",B2:B9)Total Pen quantity
=SUMIF(D2:D9,"South",B2:B9)Total quantity sold in the South
=SUMIF(B2:B9,">=10")Add only the quantities that are 10 or more
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use SUMIF at work
- Personal budgeting
Total what you spent on categories that went over plan.
Data: Monthly budget (fictional)=SUMIF(C2:C7,">200") - Sales
Sales by region.
Data: Office supplies sales (fictional)=SUMIF(D2:D9,"North",B2:B9)
Common mistakes and tips
- The tested range and the sum range must line up row for row.
- For more than one condition use SUMIFS. Note that SUMIFS puts the sum range first.
Works in
All versions of Excel, and Google Sheets.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.