AVERAGEA(value1 [,value2] [..]) |
Returns the arithmetic mean of non blank cells in a list, table or cell range (including logical values and text). |
value1 | The first value. |
value2 | (Optional) The second value. |
Remarks |
* This function is identical to the AVERAGE function except that logical values and text are included in the denominator. * This function includes hidden rows. * Arguments that are numbers are included. * Arguments that are zero are included. * Arguments that are dates are included. * Arguments that evaluate to True are included and 1 is used. * Arguments that evaluate to False are included and 0 is used. * Arguments that are text are included and 0 is used. * 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 AVERAGE function to return the arithmetic mean of non blank cells in a list, table or cell range. * You can use the AVERAGEIFS function to satisfy multiple conditions. * You can use the AVERAGEAVISIBLE - User Defined Function if you want to exclude hidden rows. * For an illustrated example refer to the page under Quant > Central Tendency > Mean. * This is similar to the COUNTA function. * This is similar to the MAXA function. * This is similar to the MINA function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top