The syntax of the AVERAGEIFS function
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)
Like in the previous function, average_range is where Excel will look for the numbers to include in the average.
Note that this is the first argument in the formula, instead of the last.
criteria_range1 is the group of cells that Excel will apply the first criteria to.
criteria1, then, is the logical statement (like “<>5”) that Excel applies on that range.
You can include as many sets of criteria_ranges and criteria as you’d like. We’ll see how that works now.