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.


  • 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


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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.