AVERAGE
Finds the mean of a list of numbers.
How it’s written
AVERAGE(range)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=AVERAGE(B2:B6)Result: 80
Adds the five scores and divides by 5.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Blank cells are skipped, but a 0 counts. That can change the result more than you’d expect.
Practice it properly
Average, highest and lowest gives you real tasks, with your formulas tested on data you haven’t seen.