Criteria– This is a condition based on which cells will be averaged. It could be a number, cell reference, text value, logical statement (like “<5”), or expression. average_range– The cell range to average. It is optional. In the absence of an average range, the range is used to...
Privacy Statement Third-Party Cookies Accept Reject Manage cookies Learn Discover Product documentation Development languages Topics Sign in We're no longer updating this content regularly. Check the Microsoft Product Lifecycle for information about how this product, service, technology, or ...
If you reject optional cookies, only cookies necessary to provide you the services will be used. You may change your selection by clicking “Manage Cookies” at the bottom of the page. Privacy Statement Third-Party Cookies Accept Reject Manage cookies ...
Excel Developer Reference Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. Syntax expression.AverageIf(Arg1,Arg2,Arg3) expressionA variable that represents aWorksheetFunctionobject. Parameters NameRequired/OptionalData TypeDescription ...