Excel AVERAGE function
To calculate the average (or mean) of the given arguments, we use the excel function average. In AVERAGE ,maximum 255 individual arguments can be given and the arguments which can include numbers / cell references/ ranges/ arrays or constants.
Syntax :
= AVERAGE(number1, [number2], ...)
- Number1 (Required) : It specifies the Range, cell references or first number for which we want the average to be calculated.
- Number2 (Optional) : Numbers, cell references or ranges which are additional for which you want the average.
For example: If the range C1:C35 contains numbers, and we want to get the average of those numbers, then the formula is : AVERAGE(C1:C35)
Note:
- Those values in a range or cell reference argument which has text, logical values, or empty cells, are ignored in calculating average.
- Cells with the value zero are included.
- Error occur if the arguments have an error value or text that cannot be translated into numbers.
Let us look at the same example to calculate the average age of all the customers from row 2 to row 12 using the formula : AVERAGE(B2:B12).
If we have a row containing non-numeric value, it is ignored as :
Here average of rows from B2 to B6 was taken, but B5 is not included in the average as it contain non numeric data.
You can see that in column B : we have done B7 = AVERAGE (B2 : B6) .
So AVERAGE() will evaluate as = 9+8+8+9 / 4 = 8.5
How To Calculate Average in Excel? ( Formula & Examples)
Whether you’re a student crunching numbers for a project, a business analyst examining sales data, or simply someone looking to get insights from personal data, mastering the art of calculating averages in Excel can significantly enhance your data-handling capabilities.
In this article, we’ll look at the basic average functions in Excel along with examples and even touch on some tricks for handling more specific needs.