Adding up matches with SUMIF
Add up the sales for each team.
SUMIF adds only the rows that match: where to look, what to match, what to add.
Work out each team's total sales in F2:F5. Write one formula in F2 and copy it down.
Typing formulas is easiest on a computer with a keyboard.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Name | Team | Sales | Team | Total sales | ||
| 2 | Tariq | West | 600 | North | |||
| 3 | Nadia | West | 800 | South | |||
| 4 | Daniel | North | 290 | East | |||
| 5 | Quinn | South | 900 | West | |||
| 6 | Jamal | North | 680 | ||||
| 7 | Isla | East | 420 | ||||
| 8 | Kofi | West | 340 | ||||
| 9 | Yusuf | North | 640 | ||||
| 10 | Sam | South | 870 | ||||
| 11 | Rosa | West | 840 | ||||
| 12 | |||||||
| 13 | |||||||
| 14 | |||||||
| 15 |
How SUMIF works
What does
SUMIFdo?SUMIFadds up only the rows that match something:=SUMIF(where to look,what to match, what to add up) How does
SUMIFline up the numbers?=SUMIF(B2:B11,"North", C2:C11) This looks for North in column B and adds up the sales next to each one in column C. The first and last ranges should cover the same rows, so each sale lines up with its team.
What if you leave out the third part?
SUMIFthen adds up the cells it checked instead, which is only useful for numbers. Otherwise it works just likeCOUNTIF, with one extra part: the numbers to add up.
Know someone fighting with a spreadsheet? Send them this page.