AVERAGE 
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. * For an illustrated example refer to the Central Tendency page. * This function includes hidden cells. * Arguments that are numbers are included. * Arguments that are numbers passed as text ("3") are included. (Row 15) * Arguments that are zero are included. * Arguments that are dates are included and the date serial number will be used. (Row 12) * Arguments that are cell references to cells containing logical values are excluded. (Row 11) * Arguments that are arrays containing logical values are excluded. (Row 20) * Arguments that are just logical values are included. (Row 19) * Arguments that are cell references to cells containing text are excluded. (Row 10) * Arguments that are arrays containing text are excluded. (Row 17) * Arguments that are just text will generate a #VALUE! error. (Row 16) * If any cell references are empty, then these are excluded. (Row 8) * If any cell references contain an error, then that error is returned. (Row 14) * You can have a maximum of 255 arguments. * You can use the AVERAGEA function to include logical values and text. * You can use the AVERAGEIFS function to satisfy multiple conditions. * You can use the AGGREGATE function to exclude hidden cells. * You can use the AVERAGEVISIBLE  User Defined Function to exclude hidden cells. * This is similar to the COUNT, MAX, MIN and SUM functions. * 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 * For the Google documentation refer to support.google.com 

1  What is the average (or arithmetic mean) of 2 and 4. 6 divided by 2. 2  What is the average of 5, 10 and 15. 30 divided by 3. 3  What is the average of 5, 10, 15 and 0. Zeros are always included. 30 divided by 4. 4  What is the average of 2, 3, 4, 5 and 6. 10 divided by 5. 5  What is the average of 2, 3, 4, 5 and 6 passed in as an array. 10 divided by 5. 6  What is the average of the values in the range "B1:B3". 30 divided by 3. 7  What is the average of the values in the range "B1", "B2" and "B3". 30 divided by 3. 8  What is the average of the values in the range "B1", "B2", "B3" and "B4". B4 is empty. Empty cells are always excluded. 30 divided by 3. 9  What is the average of the values in the range "B1", "B2", "B3" and "B5". B5 is zero so this gets included. 30 divided by 4. 10  What is the average of the values in the range "B1", "B2", "B3" and "B6". B6 is text so this is excluded. 30 divided by 3. 11  What is the average of the values in the range "B1", "B2", "B3" and "B7". B7 is a logical value so this is excluded. 30 divided by 3. 12  What is the average of the values in the range "B1", "B2", "B3" and "B8". B8 is a date so this gets included as a date serial number. 13  What is the average of the values in the named range that refers to the range "B1:B3". 30 divided by 3. 14  What is the average of the values in the range "B5", "B6" and "B9". B9 contains an error so that gets returned. 15  What is the average of the values 2 and "3". Text values that are actually numbers are included. 16  What is the average of the values 2 and "some text". The text generates an error. 17  What is the average of the values 2 and "some text" passed in as an array. The text is excluded. 2 divided by 1. 18  What is the average of the values 2 and the logical value True. TRUE is replaced with 1 so the logical value gets included. 3 divided by 2. 19  What is the average of the values 2 and the logical value False. FALSE is replaced with 0 so the logical value gets included. 2 divided by 2. 20  What is the average of the values 2 and the logical value True passed in as an array. The logical value is excluded. 2 divided by 1. 
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top