For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical

AVERAGEA Function

Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE as 0, and TRUE as 1


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

AVERAGEA(number1,number2,...)

  • number1  Required. The first numeric argument or reference that you want to average.
  • number2, ... Optional. 1 to 255 numeric arguments or references that you want to average.

Applies To

Excel 2003 and above

Remarks

  • The arguments should be values, range names, arrays, or references.
  • All text, including numbers represented as text, are evaluated as zero.
  • TRUE is evaluated as 1
  • FALSE is evaluated as 0
  • Empty cells are ignored, but cells with null strings—those that contain the single-quote character—are evaluated as zero.

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards