Explanation

Use AVERAGE function to calculate the arithmetic mean of a range of cells.

Syntax

=AVERAGE(number1,[number2],[number3]…)

We can type specific numbers or cells in this function, or just select a range we’d like to check. For example, to calculate the average for the D3:D7 range, we’ll type:

=AVERAGE(D3:D7)

Practice AVERAGE function

Now, let’s try to calculate the average age of the following people!