Averageifs formula in Excel is used to calculate averages based on multiple conditions so it Returns the average of all cells that meet multiple criteria.
The AVERAGEIFS formula in Excel syntax has the following arguments:
Average_range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria_range1, criteria_range2, … Criteria_range1 is required, subsequent criteria_ranges are optional. 1 to 127 ranges in which to…