Sum revenue by region with SUMIF
BeginnerWhen you have a long list of transactions, you often need to roll them up by category. SUMIF lets you add up numbers that match one condition, without sorting or filtering your data.
In this exercise, you have a transaction log in rows 2–9 with three columns: Region, Product, and Revenue. Your job is to fill in column B of the summary section below (rows 11–14) with the total revenue for each region.
How SUMIF works:
=SUMIF(range, criteria, sum_range)
- range: the column you want to check for a match
- criteria: the value you want to match (can be a cell reference or a text value)
- sum_range: the column you want to add up when a match is found
What you need to do:
- Click cell B11 (next to "North").
- Type a SUMIF formula that looks through the Region column (A2:A9) for entries matching the label in A11, and adds up the corresponding Revenue values (C2:C9).
- Press Enter.
- Copy the formula from B11 down to B12, B13, and B14.
When you're done, each row in the summary table should show the correct total revenue for that region.
Need some help?
Hint 1
Use A11 as the criteria argument rather than typing the text "North" directly. That way, when you copy the formula down, each row automatically picks up its own region label from column A.
Hint 2
Lock the range and sum_range with dollar signs ($A$2:$A$9 and $C$2:$C$9) so those references stay fixed as you copy the formula down. The criteria cell (A11, A12, and so on) should remain a relative reference so it shifts with each row.
Sum revenue by region with SUMIF
BeginnerWhen you have a long list of transactions, you often need to roll them up by category. SUMIF lets you add up numbers that match one condition, without sorting or filtering your data.
In this exercise, you have a transaction log in rows 2–9 with three columns: Region, Product, and Revenue. Your job is to fill in column B of the summary section below (rows 11–14) with the total revenue for each region.
How SUMIF works:
=SUMIF(range, criteria, sum_range)
- range: the column you want to check for a match
- criteria: the value you want to match (can be a cell reference or a text value)
- sum_range: the column you want to add up when a match is found
What you need to do:
- Click cell B11 (next to "North").
- Type a SUMIF formula that looks through the Region column (A2:A9) for entries matching the label in A11, and adds up the corresponding Revenue values (C2:C9).
- Press Enter.
- Copy the formula from B11 down to B12, B13, and B14.
When you're done, each row in the summary table should show the correct total revenue for that region.
Need some help?
Hint 1
Use A11 as the criteria argument rather than typing the text "North" directly. That way, when you copy the formula down, each row automatically picks up its own region label from column A.
Hint 2
Lock the range and sum_range with dollar signs ($A$2:$A$9 and $C$2:$C$9) so those references stay fixed as you copy the formula down. The criteria cell (A11, A12, and so on) should remain a relative reference so it shifts with each row.