Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

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


AVERAGE(  ,  ,  

Related functions