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

AVERAGE

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

Sample Usage

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

Syntax

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

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

Examples

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

Notes

  • Any text encountered in the arguments will be ignored. To include logical values and text representations of numbers as part of the calculation, use the AVERAGEA function.
  • Cells with the value of zero are included in the calculation.