AVERAGE function


Average function.

AVERAGE(range) computes the arithmetic mean of the contents of the cells in the specified range. If one of the cells in range does not have a numeric value, but is empty or has a string value, then this cell will not be taken into account for calculating the average, or any of the other statistical functions.


AVERAGE(A1:A8) returns the mean of the contents of cells A1 to A8.

AVERAGE function



Related functions

This site uses cookies to store information on your computer. More info...