AVERAGE
Returns the average of its arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
What it does
Returns the arithmetic mean of numbers (ignores empty cells and text).
Syntax
AVERAGE(number1, [number2], ...)
Arguments
number1(number|range) — First number or range to average.
Examples
Average a range
Compute the average of A2:A6.
FORMULA
=AVERAGE(A2:A6)
RESULT
13
SAMPLE DATA
| A | |
|---|---|
| 1 | Score |
| 2 | 10 |
| 3 | 12 |
| 4 | 8 |
| 5 | 15 |
| 6 | 20 |