Description

This function calculates the average from a list of numbers.

Arguments can either be numbers or names, ranges, or cell references that contain numbers.

Logical values and text representations of numbers that you type directly into the list of arguments are counted.

AVERAGE function can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

If an [group of selection]array or cell reference argument contains text, logical values, or empty cells, those values ​​are ignored. However, The value of that cell is zero are included.

Arguments that are error values or text that cannot be translated into numbers cause errors.

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.

If you want to calculate the average of only the values that meet certain criteria, use the AVERAGEIF function or the AVERAGEIFS function.

Return value

Returns the average of the arguments.

Syntax

=AVERAGE(number1, [number2], ...)

Arguments

number1 :  A number or cell reference that numeric value.

number2 :  [optional] (this is optional) A value or reference to a value that can be evaluate as a number 

For example =AVERAGE (2,5,6,7,10) returns 6.

Manual calculation method:

 2  +  5  +  6  +  7  +  10  =  30 / 5 =  average of numbers  6 

Example

Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers.

For example, the average of 1, 2, 3, 4, 5, and 15 is 30 divided by 6, which is 5.

 1  +  2  +  3  +  4  +  5  +  15  =  30 (result )  average of numbers  5 

30 /  6   (count of numbers) =  5  (this result is average value of numbers) 

Median, which is the middle number of a group of numbers

For example, the median of 2, 3, 3, 5, 7, and 10 is 4.

Mode, which is the most frequently occurring number in a group of numbers.

For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.