← Back to level 1
Level 1Level 1
AVERAGE
Calculates the arithmetic mean for a list of values.
Syntax
=AVERAGE(number1, number2, ...)Step-by-step explanation
- 1Pick a range that contains the values you want to average.
- 2Enter the formula in an empty cell.
- 3Use it for score analysis, performance reports, or reporting trends.
Common mistakes
Including blank cells unexpectedly
Averaging text values
Using SUM instead of AVERAGE
Example table
A quick scenario to connect the syntax to the result.
| 10 | 20 |
| 15 | 25 |
Formula
=AVERAGE(A1:B2)
Result
17.5
Practice area
Find the average of the sample data.
Match against the syntax block above.