AVERAGEA « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. AVERAGEA
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