Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

AVERAGEA(value1,value2, ) returns the average of its arguments, including numbers, text, and logical values

Input the formula: =AVERAGEA(B1:B6). Press Enter to get the result. Referenced from Excel Help