CONDITIONAL ANALYSIS · ORIGINAL EXERCISE
Northern average
Calculate average revenue for North-region orders.
This quest practices AVERAGEIF using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Order | Region | Product | Units | Revenue | Cost |
|---|---|---|---|---|---|
| O-101 | North | Keyboard | 12 | 720 | 420 |
| O-102 | South | Mouse | 18 | 450 | 198 |
| O-103 | North | Monitor | 5 | 1250 | 900 |
| O-104 | West | Keyboard | 8 | 480 | 280 |
| O-105 | South | Monitor | 4 | 1000 | 720 |
| O-106 | North | Mouse | 20 | 500 | 220 |
| O-107 | West | Monitor | 6 | 1500 | 1080 |
| O-108 | North | Keyboard | 10 | 600 | 350 |
Hints to get you started
- Check the region column.
- Average the matching revenue values.
- AVERAGEIF has the same argument order as SUMIF.
Show the worked solution
=AVERAGEIF(B2:B9,"North",E2:E9)AVERAGEIF divides matching numeric revenue by its matching numeric count.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →