#### The Excel Average() function

The *average()* function is very similar to the *sum()* function: it receives a range of cells, and returns the average of all the numbers that appear in that range (i.e. the sum of all the cells divided by the number of cells).

The following sheet contains a list of kinder-garden kids and their height:

The following formula will show us the average height of the entire kinder-garden population:

=AVERAGE(B2:B16)

As shown here...