AVERAGEIF(range, criteria [,average_range])
Returns the arithmetic mean of all the numbers in a range that satisfies one condition.
|range||The range of cells you want evaluated.|
|criteria||The expression that contains the criteria.|
|average_range||(Optional) The actual cells to average.|
|* Added in Excel 2007.|
* This function includes hidden rows.
* This function uses the actual cell values and not the displayed formatted values.
* If no cells in "average_range" meet the criteria, then #DIV/0! is returned
* Arguments that are logical values are excluded.
* Arguments that are zero are included.
* Arguments that are text are excluded.
* If any cell references contain an error, then that error is returned.
* If any cell references are empty, then these are ignored.
* The "criteria" can contain wildcard characters (?) for a single character and (*) for any sequence of characters. To include these characters prefix them with a tilda (~?) and (~*).
* You can use the AVERAGE function to return the arithmetic mean with no conditions.
* 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.
* If you want to use a VBA function instead you can use the User Defined Function
* This is similar to the COUNTIF function.
* This is similar to the SUMIF function.
* For the Microsoft documentation refer to support.office.com
1 - What is the average of all the values in the range "C1:C5" which have 14,000 in the range "B1:B5".
© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited Top