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!