How to use Excel AVERAGE Function

how to use excel average function

Quick Intro

Use Excel AVERAGE Function to calculate the average of given numbers. In simple words, it will first sum the numbers and then divide that sum by the count of numbers.

For example, for 10, 20, 30 it will return 30 as an average.

Syntax

AVERAGE(number1,number2,…)

  • number1 A numeric value for which you want to get the average.
  • [number2] A numeric value for which you want to get the average.

More Information on Excel AVERAGE Function

  • You can specify an argument as a number, named range or a cell reference.
  • It will ignore an empty cell, a cell with a text, and a cell with a logical value.
  • If a cell has 0 in it, it will count that cell to calculate average.
  • If you enter a logical value or a text which represents a number as an argument directly into the function, that will be counted.
  • It will return an error if an argument is an error value or a text value which cannot be converted into a number.

Examples

In the below example, we have entered arguments directly into the function. As I have already mentioned, you can specify maximum 255 arguments.

Defination Excel AVERAGE Function

In the below example, we have referred to a range which has numbers. You can refer to the unlimited cell by using a continues range. And, if you want to refer to a dynamic range you can use a table for that.

Examples Excel AVERAGE Function

If any of the cells which is referred has an error value it will return an error in the result.

Examples Excel AVERAGE Function With Error

In the below example, we have referred to a range in which cells are formatted as a text value. In this case, you can convert those text numbers into the actual numbers to calculate average.

Examples Excel AVERAGE Function With Text Format

A cell will also be ignored if that cell is preceded by an apostrophe.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have AVERAGEA function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.