average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...

!average_range,criteria_range,criteria,...!!Finds average(arithmetic mean) for the cells specified by a given set of conditions or criteria!are the actual cells to be used to find the average.!is the range of cells you want evaluated for the particular condition!is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average!