How to use AVERAGE Function in Excel.

blog img


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.


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


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

Note: The AVERAGE function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. The three most common measures of central tendency are below :


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.

Formula Description Result
=AVERAGE(C4:H4) Average of the numbers in cells C4 to H4. 83.5
=AVERAGE(B7:B10) Average of the numbers in cells B7 to B10. 12
=AVERAGE(E7:E11) Average of the numbers in cells E7 to E11. A added in E11 cell but ignored. 12

Share your thoughts

Your email address will not be published. All fields are required.

Related post

  1. How to use LOWER Function in Excel

    Excel Lower Function…

  1. How to use ADDRESS Function in Excel

    The ADDRESS function…

  1. How to use ACOSH function in excel

    The ACOSH function…

  1. How to use ACOT function in excel

    The Excel ACOT…

  1. How to use ACOS function in excel

    This function is…