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
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
In above example, I have entered arguments directly into the function. As I have already mentioned you can specify maximum 255 arguments.
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.
If any of the cells which is referred has an error value if will return an error in the result.
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
Use Excel AVERAGE Function to calculate the average of numeric values. Learn more about AVERAGE from here.