Returns the average value of a series of numbers and/or cells.
AVERAGE(value1, [value2, ...])
- value1 - The first number or range to consider while calculating the average value.
- value2, .. - [OPTIONAL] Additional numbers or ranges to consider.
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.
- 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.