Excel SUMIF Practice Question: Using SUMIF, find the total sales for the North region and put it in E2.
The question
Using SUMIF, find the total sales for the North region and put it in E2.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Rep | Sales | North total | |
| 2 | North | Asha | 12500 | ? | |
| 3 | South | Ravi | 8400 | ||
| 4 | North | Meera | 9800 | ||
| 5 | East | Kabir | 15200 | ||
| 6 | South | Nina | 7600 | ||
| 7 | North | Arjun | 11300 |
The yellow cell is where your answer goes.
Show answer
Answer in E2: 33600
How it works
Explanation: SUMIF adds up only the rows that meet one condition. It checks one range for the condition and sums a matching range.
Syntax: =SUMIF(range, criteria, [sum_range])
North rows are 12500, 9800 and 11300. 12500 + 9800 + 11300 = 33600.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →SUMIF syntax
=SUMIF(range, criteria, [sum_range])
Adds up numbers, but only the ones that meet a condition. SUMIF is used in financial models and engineering-style calculations where precise numeric work is needed. Full SUMIF guide.
All practice questions · Excel exercises · Interview prep · Cheat sheet