Beginner
Math
AVERAGE
Calculates the arithmetic mean of a range of numbers.
Compatibility: All Excel versions
Syntax
=AVERAGE(number1, [number2], ...)
Example
=AVERAGE(B2:B20)
When to Use It
Use AVERAGE to find a typical value across a data set, like an average test score or average monthly spend.