SUMIF: total one category
Add up only the rows that belong to the group you were asked about.
Task:
The order log mixes three regions. In F2:F4 give the total order value for each region listed in E2:E4.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of SUMIF
0/4The same formula in the other shapes it takes at work.
- SUM with Multiple Values
Sum values from multiple non-adjacent cells or ranges.
CoreIntermediate - SUMIF: total one category
Add up only the rows that belong to the group you were asked about.
Intermediate - SUMIFS: total with two conditions
One region and one product at the same time.
Advanced - SUMIF with a comparison
Add up only the values above a line — the criterion can be a comparison, not just a match.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Value | Region | Total | |
| 2 | A-101 | North | 420 | North | ||
| 3 | A-102 | South | 380 | South | ||
| 4 | A-103 | North | 610 | West | ||
| 5 | A-104 | West | 255 | |||
| 6 | A-105 | South | 490 | |||
| 7 | A-106 | North | 175 | |||
| 8 | A-107 | West | 830 |
What this exercise teachesMay contain the answer
Picking the cells by hand, as =C2+C4+C7, works until the log is sorted or a new order arrives. SUMIF describes which rows count rather than listing them, so it stays right as the data moves.