The Excel Averagea function returns the arithmetic mean of a list of supplied numbers.
where the value arguments are a set of one or more numeric values, or arrays of numeric values, for which you want to calculate the average - these values can be supplied directly to the function, or as one or more cells or ranges of cells containing numeric values.
In Excel 2007 and later versions of Excel, you can provide up to 255 number arguments to the Averagea function, but in Excel 2003, the function can only accept up to 30 arguments. However, each argument can be an array of values or a range of cells, each of which can contain many values.
|AVERAGE Function||AVERAGEA Function|
|Logical values or text representations of numbers, typed directly into the list of arguments||ARE counted|
|Text that cannot be interpreted as a number, typed directly into the list of arguments||#VALUE! error||#VALUE! error|
|Logical values, within arrays or reference arguments||Ignored||ARE counted|
|Text (including empty text "", text representations of numbers, or other text), within arrays or reference arguments||Ignored||Counted as zero|
The following spreadsheet shows the Excel Averagea function used to calculate the arithmetic mean of the values 8, 1, 9, 6 & 10. Although the same 5 values are provided to each of the functions in cells B1-B4, in each case, the values are provided to the function in different ways.
Further examples of the Excel Averagea function can be found on the Microsoft Office website.