Find the average with AVERAGE
Step 1 of 3
The average is the total divided by how many numbers there are. Five scores that add up to 390 have an average of 390 / 5 = 78.
Click Continue when you're ready.
Already know it? Type the formula straight into B7.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Student | Score | ||||
| 2 | Anna | 72 | ||||
| 3 | Ben | 85 | ||||
| 4 | Cara | 90 | ||||
| 5 | Dan | 64 | ||||
| 6 | Eva | 79 | ||||
| 7 | ||||||
| 8 |
Need help?
Why this works
AVERAGE adds the numbers in the range and divides by how many numbers there are: 390 / 5 = 78. Select the whole column of scores, B2:B6, and leave the header out.
Common mistake: Dividing a SUM by a typed count, like =SUM(B2:B6)/5. Add a score and the 5 is wrong; AVERAGE counts for you.
The answer
- B7
=AVERAGE(B2:B6)
Type =AVERAGE( and select the cells, then close the parenthesis and press Enter, for example =AVERAGE(B2:B6).
+10 points