AVERAGEA(value1,value2,...) returns the average of its arguments, including numbers, text, and logical values : AVERAGEA « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. AVERAGEA
Input the formula: =AVERAGEA(B1:B6). Press Enter to get the result.
Input the formula: =AVERAGEA(B1:B6)

Referenced from Excel Help

21.2.AVERAGEA
21.2.1.AVERAGEA(value1,value2,...) returns the average of its arguments, including numbers, text, and logical valuesAVERAGEA(value1,value2,...) returns the average of its arguments, including numbers, text, and logical values
21.2.2.=AVERAGEA(A2:A5,A17) returns Average of the numbers above, and the empty cell=AVERAGEA(A2:A5,A17) returns Average of the numbers above, and the empty cell