Returns the average (arithmetic mean) of the arguments. For example, if the range. The cells in a range can be adjacent or nonadjacent.) A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.