AVERAGE()
Calculates the arithmetic mean of a set of numbers.
AVERAGE(number1, [number2], ...)AVERAGE adds up the numbers you give it and divides by how many there are. It ignores blank cells and text, but a cell containing 0 still counts toward the total.
For an average with a condition, use AVERAGEIF or AVERAGEIFS.
Arguments
- number1
- A number, cell reference, or range to average.
- number2, ...optional
- Additional numbers, cells, or ranges to include.
Examples
=AVERAGE(B2:B20)→2,539
The mean of every value in the range.