SUM, AVERAGE, MIN & MAX practice exercises
SUM, AVERAGE, MIN and MAX are the first formulas everyone needs: totals, averages and the highest and lowest values in a column. MEDIAN gives the middle value, which is often more honest than the average when there are outliers.
Syntax
SUM(range) · AVERAGE(range) · MIN(range) · MAX(range) · MEDIAN(range)
range- A block of cells like
F2:F9. You can also list several ranges separated by commas.
The practice data
An orders table: who sold what, where, and for how much. Every exercise below uses this sheet, and your answer goes in H2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Units | Price | Sales |
| 2 | Ana | East | Widget | 12 | 5 | 60 |
| 3 | Ben | West | Gadget | 5 | 20 | 100 |
| 4 | Cara | East | Gadget | 8 | 20 | 160 |
| 5 | Dev | North | Widget | 20 | 5 | 100 |
| 6 | Ana | West | Gizmo | 3 | 50 | 150 |
| 7 | Ben | East | Widget | 7 | 5 | 35 |
| 8 | Cara | North | Gizmo | 2 | 50 | 100 |
| 9 | Dev | East | Gadget | 6 | 20 | 120 |
Worked example
=SUM(F2:F9)
Adds up all 8 Sales values. Result:
| 825 |
Your turn: 3 exercises
Type a formula and press Enter. It is checked by a real formula engine, so any correct approach counts.
1 Return the average Units per order.
2 Return the difference between the largest and smallest Sales value.
3 Return the median Sales value.
Practice SUM, AVERAGE, MIN & MAX in the full lesson, free
Lesson 2 has more exercises in a real spreadsheet grid, with hints and progress tracking. No card needed.
Open lesson 2Common SUM, AVERAGE, MIN & MAX mistakes
- Including the header row in the range. Text is ignored by SUM, but it is a habit that causes errors elsewhere.
- Typing numbers into the formula (
=60+100+...) instead of referencing cells, so it doesn't update. - Confusing COUNT (counts numbers) with COUNTA (counts anything that isn't empty).
FAQ
Why does my SUM show 0?
The numbers are probably stored as text, often after pasting. Convert them with VALUE or Data → Split text to columns.
AVERAGE or MEDIAN?
AVERAGE is pulled up or down by extreme values; MEDIAN is the middle value and ignores outliers.