deepcalc
DocsAVERAGE

AVERAGE

View as markdown/docs/functions/average.md Ask Claude about this pageOpens Claude with this page's address

Calculates arithmetic mean.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=AVERAGE(A1:A10)
A
1 10
2 20
3 30
4 40
5 50
Result 30
=AVERAGE(10, 20, 30)
Result 20

Syntax

AVERAGE(number…)
number…
number required
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.