AVERAGE

Returns the average.

AVERAGE requires at least one argument. You can use single arguments and/or scope arguments.

Example

AVERAGE(A1:A5) returns the average of the values saved in the cells A1 to A5.