=AVERAGEA(A2:A5,A17) returns Average of the numbers above, and the empty cell : AVERAGEA « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. AVERAGEA
Input the formula: =AVERAGEA(A2:A5,A17). Press Enter to get the result.
Input the formula: =AVERAGEA(A2:A5,A17)
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