Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

AVERAGEA

Returns the average value of a series of numbers and/or logical statements.

Sample Usage

AVERAGEA(20:30)
AVERAGEA(A2:A6)
AVERAGEA(A1:B2,5)

Syntax

AVERAGEA(value1, [value2, ...])

  • value1 - The first number or range to consider while calculating the average value.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to consider.

Examples

AVERAGEA(20,30) returns a value of 25.
AVERAGEA(A2:A6) returns the average of the values in cells A2 through A6.
AVERAGEA(A1:B2,5) returns the average of the values contained in cells A1 through B2 and the number 5.

 

Notes

  • Cells that contain TRUE or FALSE evaluate to 1 or 0 respectively. 
  • Array or reference arguments that contain text evaluate as 0 (zero). Empty text ("") evaluates as 0. (zero). To exclude logical values and text representations of numbers as part of the calculation, use the AVERAGE function.