Functions
AVERAGE
Arithmetic mean of arguments
Try it
When to use it
When should I use AVERAGE instead of SUM?
Use AVERAGE to find the typical (mean) value of a set of numbers; use SUM when you just want the total.
Does AVERAGE count blank or text cells?
No. AVERAGE ignores blanks and text and divides only by the count of numeric values, so empty cells never drag the result toward zero.
Use cases
Average monthly revenue from an inline array
Average temperature reading
Used in
Syntax
AVERAGE(value1,...)Examples
=AVERAGE(1,2,3,4,5,6,7,8,9,10,4,26) // => 7.083333333333333
=AVERAGE(1,2,3,4,5,7,8,9,10,11,12) // => 6.545454545454546