The AVERAGEIF and AVERAGEIFS Function in Excel

The AVERAGEIF and AVERAGEIFS function in Excel are predefined functions that calculate the arithmetic mean based on specified criteria. You can use either function to calculate the average value of a range of data when they meet specified conditions.