AVERAGEA()
Syntax. AVERAGEA(value1,value2,...)
Definition. This function calculates the average of the values in an argument list. Not only numbers but also text and logical values (TRUE and FALSE) are included in the calculation.
Arguments
value1 (required) and value2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the average
Note
The arguments can be numbers, names, arrays, or references.
Tip: Show a zero in cells with zero values
Remember that empty cells are treated differently from cells with the value 0. Empty cells are not counted, but 0 values are. If you activate the zero values option for cells with the value 0, you can see which cells are really empty and which contains ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.