AVERAGE(number1 [,number2] [..]) |
Returns the arithmetic mean of non blank cells in a list, table or cell range. |
| number1 | The first number. |
| number2 | (Optional) The second number. |
Remarks |
| * The arithmetic mean is the most common measure of central tendency. * This function includes hidden cells. * Arguments that are numbers are included. * Arguments that are zero are included. * Arguments that are dates are included. * Arguments that are logical values are excluded from the denominator. * Arguments that are text are excluded from the denominator. * If any cell references are empty, then these are excluded. * If any cell references contain an error, then that error is returned (Row 15). * You can have a maximum of 255 arguments. * You can use the AVERAGEA function to include logical values and text in the denominator. * You can use the AVERAGEIFS function to satisfy multiple conditions. * You can use the AVERAGEVISIBLE - User Defined Function to exclude hidden cells. * You can use the AGGREGATE function to exclude hidden cells. * This is similar to the COUNT function. * This is similar to the MAX function. * This is similar to the MIN function. * This is similar to the SUM function. * For an illustrated example refer to the Quant > Central Tendency > Mean page. * You can enter the abbreviated function name "=AVG()" although you will be prompted to change this to "AVERAGE". * For the Microsoft documentation refer to support.microsoft.com |
|
| 1 - What is the arithmetic mean or average of 2 and 4. 2 - What is the arithmetic mean or average of 5, 10 and 15. 3 - What is the arithmetic mean or average of 5, 10, 15 and 0. Zeros are included. |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top