The AVERAGE function

The AVERAGE function is a statistical function which returns the average of the numerical values in the identified range, if presented with non-numeric values it will ignore those values in its calculations.

This is the format of the AVERAGE function:

= AVERAGE( Range 1, Range 2, Range 3, etc…)

AVERAGE function returning the sum of all valid arguments divided by the count of all valid arguments

Here is an example of the AVERAGE function:

= AVERAGE( 1, 2, 3, 4, 5) = 3

= AVERAGE( 3, 4, 8) = 5

This function is useful to calculate things like average sales, held inventory, or cost of a recurring expense across a period of time.

An example of a functional implementation of this would be if you are a car rental service and trying to calculate the average amount of gas you put every time you go fill up a tank of a returned rental vehicle.

= AVERAGE( 45.30, 22.63, 19.48, 37.90, 15.78, 33.69) = 29.13