The AVERAGE function returns the arithmetic mean of its arguments.
The syntax is the following:
AVERAGE(n1, [n2],…)
n1, n2, … : A number, cell reference or range for which you want to calculate the average
n2, … : optional arguments that can be up to a maximum of 255
If the cell range or references in the arguments contain text, logical values or are empty they are ignored.
If they contain error values then the calculation of the AVERAGE function results to an error as well.
The arithmetic mean (AVERAGE) is a function that measures central tendency. If you want to know more about all the functions of Excel that are used to measure central tendency in statistics then you can visit our tutorial Calculate the central tendency using Excel
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here are some examples of all the possible uses of AVERAGE:
In the cell E116 enter a function that calculates the average cost of the products displayed in the cell range Ε3:Ε110.
Use the appropriate function to calculate in the cell B12 the AVERAGE of the cell range B4: B10.
Use the appropriate function in the cell G12 to calculate the average of the values displayed in the cell range G5:G10.
Use the appropriate function in the cell J4 to calculate the average number of items sold in April.
Navigate to the cell C14 of the active worksheet and insert there the appropriate function to display the average of the values of the cell range D6:D9.
In the cell D19 calculate the average of Total Questions. Reference the data by using the structured reference of the table.
In the cell B1 of the Total worksheet insert the appropriate function to sum up the cells within the cell range A1:A10 from the FF1 worksheet through to the FF12 worksheet.
Insert in the cell B2 a function that returns the average of the respective cell range, in cell B3 for the minimum, in cell B4 for the maximum and in cell B5 for the total of cells displaying numbers, following the same pattern.