AVERAGE - Docs Editors Help
support.google.com · 292 words · saved by 1 readers
The AVERAGE function returns the numerical average value in a dataset, ignoring text. Examples Make a copy
The AVERAGE function returns the numerical average value in a dataset, ignoring text. Examples Make a copy Sample Usage AVERAGE(A2:A100,B2:B100,4,26) AVERAGE(1,2,3,4,5,C6:C20) Syntax AVERAGE(value1, [value2, ...]) value1 - The first value or range to consider when calculating the average value. value2, ... - [ OPTIONAL ] - Additional values or ranges to consider when calculating the average value. Notes Although AVERAGE is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function. Any text encountered in the value…
saved by
related reading
- Comparison Operators in Google Sheets and Equivalent Functionsinfoinspired.com
- Use conditional formatting rules in Google Sheets - Computer - Google Docs Editors Helpsupport.google.com
- Geometric mean - Wikipediaen.wikipedia.org
- Averageness - Wikipediaen.wikipedia.org
- Google Translatetranslate.google.com
- Moment (mathematics) - Wikipediaen.wikipedia.org
- algebra precalculus - Intuition and derivation of the geometric mean - Mathematics Stack Exchangemath.stackexchange.com
- Arity - Wikipediaen.wikipedia.org
- Law of large numbers - Wikipediaen.wikipedia.org
- grep_awk_sed.pdfwww-users.york.ac.uk
- Statistical parameter - Wikipediaen.wikipedia.org
- Big Osamwho.dev