Practice by topic / Excel / Counting & Averaging
Counting and averaging are how you summarise a list: how many orders, how many late, what the typical value is. Most reports start here. These 10 exercises build up step by step, starting with average sales for one region, average scores for passing students, average response time for urgent tickets.
3 of 10 free · no sign-up needed · graded on the formula you write
A1:A5 hold regions, B1:B5 hold sales amounts. Write a formula in C1 that averages sales for "West" only.
| A | B | C | |
|---|---|---|---|
| 1 | West | 100 | ? |
| 2 | East | 200 | |
| 3 | West | 150 | |
| 4 | North | 80 | |
| 5 | West | 120 |
Use =AVERAGEIF(A1:A5,"West",B1:B5)
Right — AVERAGEIF filters to matching rows before computing the average.
Expected result in C1: 123.33333333333333
A1:A5 hold pass/fail status, B1:B5 hold scores. Write a formula in C1 that averages the scores of students marked "pass".
| A | B | C | |
|---|---|---|---|
| 1 | pass | 85 | ? |
| 2 | fail | 45 | |
| 3 | pass | 92 | |
| 4 | pass | 78 | |
| 5 | fail | 50 |
Use =AVERAGEIF(A1:A5,"pass",B1:B5)
Good — AVERAGEIF only includes the scores from rows where the status matches.
Expected result in C1: 85
A1:A5 hold priority levels, B1:B5 hold response times. Write a formula in C1 that averages response time for "urgent" tickets.
| A | B | C | |
|---|---|---|---|
| 1 | urgent | 1 | ? |
| 2 | low | 8 | |
| 3 | urgent | 2 | |
| 4 | urgent | 3 | |
| 5 | low | 6 |
Use =AVERAGEIF(A1:A5,"urgent",B1:B5)
Right — this isolates just the urgent-ticket response times before averaging.
Expected result in C1: 2
A1:A5 hold stock status, B1:B5 hold prices. Write a formula in C1 that averages the price of items marked "in stock".
| A | B | C | |
|---|---|---|---|
| 1 | in stock | 20 | ? |
| 2 | out of stock | 35 | |
| 3 | in stock | 15 | |
| 4 | in stock | 25 | |
| 5 | out of stock | 40 |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:A5 hold purchase amounts. Write a formula in A6 that averages only the purchases over 50 (criteria and average range are the same here).
| A | |
|---|---|
| 1 | 30 |
| 2 | 80 |
| 3 | 20 |
| 4 | 65 |
| 5 | 90 |
| 6 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:A5 hold categories, B1:B5 hold ratings. Write a formula in C1 that averages ratings for "Electronics".
| A | B | C | |
|---|---|---|---|
| 1 | Electronics | 4 | ? |
| 2 | Books | 5 | |
| 3 | Electronics | 3 | |
| 4 | Electronics | 5 | |
| 5 | Books | 4 |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:A5 hold employment type, B1:B5 hold weekly hours. Write a formula in C1 that averages hours for "full-time" employees.
| A | B | C | |
|---|---|---|---|
| 1 | full-time | 40 | ? |
| 2 | part-time | 20 | |
| 3 | full-time | 38 | |
| 4 | full-time | 42 | |
| 5 | part-time | 15 |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:A5 hold sale flags, B1:B5 hold discount percentages. Write a formula in C1 that averages the discount for items marked "yes".
| A | B | C | |
|---|---|---|---|
| 1 | yes | 10 | ? |
| 2 | no | 0 | |
| 3 | yes | 20 | |
| 4 | yes | 15 | |
| 5 | no | 0 |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:A5 hold order sizes. Write a formula in A6 that averages only the orders under 100.
| A | |
|---|---|
| 1 | 50 |
| 2 | 120 |
| 3 | 80 |
| 4 | 200 |
| 5 | 60 |
| 6 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:A5 hold task status, B1:B5 hold durations in hours. Write a formula in C1 that averages the duration of "completed" tasks.
| A | B | C | |
|---|---|---|---|
| 1 | completed | 3 | ? |
| 2 | pending | 5 | |
| 3 | completed | 4 | |
| 4 | completed | 2 | |
| 5 | pending | 6 |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →