AVERAGEIF function

Excel Function/AVERAGEIF function

Function: AVERAGEIF function Type: Statistical Description: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria