AVERAGE function
In this method, we are going to use the AVERAGE function which returns the mean of the arguments. For example, the =AVERAGE(A1:A10) returns the average of the numbers in the range of A1 to A10.
Syntax:
AVERAGE(number1,[number2],…)
Here,
- number1 (Required): The first cell reference or number for which you want the average
- number2 (optional): Additional cell references or numbers for which you want the average. The maximum limit is 255.
Notes:
- arguments can either be numbers or names, ranges, or cell references that contain numbers.
- If the argument contains text or logical values or empty cells then those values are ignored. However, if the cell contains the value zero then it is included.
- if the argument contains error values or text that cannot be translated to numbers then it will cause errors.
- AVERAGE: This function returns the average of cells with any data (logical values or text representation of numbers)
- AVERAGEIF: This function is used to calculate the average of only the values that meet a single criterion.
- AVERAGEIFS: This function is used to calculate the average based on multiple criteria.
Example:
Let us apply the above formula on some rough data as shown below:
In the above example, we have used 4 different functions.
- =AVERAGE(c4:e12): Returns the average of the numbers in cells c4 to e12
- =AVERAGE(c4:f6,6): Computes the average of the values in cells C4 to F6 along with the number 6.
- =AVERAGE(b4:b12, “sara”, c4:c12): Calculates the average of the numbers in cells C4 to C12 by considering the instances where the name “Sara” appears within the range B4 to B12.
- =AVERAGE(d4:d12,b4:b12,”sara”,g4:g12,”b”): Determines the average of the numbers in cells D4 to D12, taking into account two conditions: occurrences of the name “Sara” within the range B4 to B12, and occurrences of the grade “B” within the range G4 to G12. .
How to Calculate Mean, Median and Mode in Excel
The mean (also called average) of the data set is calculated by adding all the numbers in the data set and then dividing it by the total number of values in the data set. In this article, we will find out how to calculate the mean in Excel.