SUMIF
Adds only the rows that meet one condition.
How it’s written
SUMIF(range_to_check, what_to_look_for, range_to_add)Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Amara | 400 |
| 3 | South | Ben | 250 |
| 4 | North | Chloe | 150 |
| 5 | West | Dev | 700 |
=SUMIF(A2:A5,"North",C2:C5)Result: 550
Adds sales for rows where the region is North.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Point the condition at a cell instead of typing it, so the total updates when that cell changes.
Practice it properly
Totals with conditions gives you real tasks, with your formulas tested on data you haven’t seen.