## 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. |

REMARKS |

* 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 |