AVERAGEIF-Function

AVERAGEIF function in Excel is used to returns the average (arithmetic mean) of all the cells with in the range which meet given criteria.