0305, 2019 The AVERAGEIF Function Kornilios Ampatzis/ May 3, 2019/ Functions It returns the arithmetic mean (average) of all the cells in a given range that meet a specific criterion.