SUMIFS
Adds only the rows that meet several conditions.
How it’s written
SUMIFS(range_to_add, range1, condition1, range2, condition2)Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Amara | 400 |
| 3 | South | Ben | 250 |
| 4 | North | Chloe | 150 |
| 5 | West | Dev | 700 |
=SUMIFS(C2:C5,A2:A5,"North",C2:C5,">200")Result: 400
Adds North sales above 200.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
SUMIFS puts the range to add first, while SUMIF puts it last. Mixing these up is very common.
Practice it properly
Totals with conditions gives you real tasks, with your formulas tested on data you haven’t seen.