HomeExcel Functions ► Excel AVERAGE Function

Syntax For Excel AVERAGE Function

What is the use of Excel AVERAGE Function?

Use Excel AVERAGE Function to calculate the average of given numbers. In simple words, it will first sum the numbers & then divide that sum by the count of numbers. For example, for 10, 20, 30 it will return 30 as an average.

Syntax for Excel AVERAGE Function

AVERAGE(number1,number2,…)

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

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

More Information on Excel AVERAGE Function

  • You can specify an argument as a number, named range &cell reference.
  • It will ignore empty cells, cells with text, cells with logical values.
  • 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 the argument is an error value or text values which cannot be converted into a number.

Examples to understand Excel AVERAGE Function

Defination Excel AVERAGE Function

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

Examples Excel AVERAGE Function

In above example, I have referred to a range which has numbers in it. 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 With Error

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

Examples Excel AVERAGE Function With Text Format

In above example, I have referred to a range in which cell has formatted as text. In this case, you can convert those text numbers into the actual numbers.

A cell will also ignore for averaging if that cell is preceded by an apostrophe.

Download Sample File

Download Sample File To Learn Excel AVERAGE Function

More Tips Related With Excel AVERAGE Function

Conclusion

Use Excel AVERAGE Function to calculate the average of numeric values. Learn more about AVERAGE from here.

Related Function

AverageIf | Averageifs

Blog | Excel Functions