What is AVERAGE?
Calculates the arithmetic mean of numbers in a range. Essential for statistical analysis, performance metrics, and trend identification.
Syntax
=AVERAGE(number1, [number2], ...)
Example
Formula: =AVERAGE(B1:B4)
Result: 22.5
How It Works
This calculates the average of values in B1 through B4. If the values are 10, 20, 30, 30, the average is 22.5. AVERAGE ignores empty cells but includes cells with zero.