AVERAGEIFS function
Summary
Returns the average (arithmetic mean) of all cells that meet multiple criteria.
Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
The AVERAGEIFS function 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 evaluate the associated criteria.
• Criteria1, criteria2, ... Criteria1 is required, subsequent criteria are optional. 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
• 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 evaluate the associated criteria.
• Criteria1, criteria2, ... Criteria1 is required, subsequent criteria are optional. 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
Example
=AVERAGEIFS(B2:B5, B2:B5, ">70", B2:B5, "<90")
=AVERAGEIFS(C2:C5, C2:C5, ">95")
=AVERAGEIFS(D2:D5, D2:D5, "<>Incomplete", D2:D5, ">80")
=AVERAGEIFS(B2:B7, C2:C7, "Bellevue", D2:D7, ">2",E2:E7, "Yes")
=AVERAGEIFS(B2:B7, C2:C7, "Issaquah", D2:D7, "<=3",E2:E7, "No")
=AVERAGEIFS(C2:C5, C2:C5, ">95")
=AVERAGEIFS(D2:D5, D2:D5, "<>Incomplete", D2:D5, ">80")
=AVERAGEIFS(B2:B7, C2:C7, "Bellevue", D2:D7, ">2",E2:E7, "Yes")
=AVERAGEIFS(B2:B7, C2:C7, "Issaquah", D2:D7, "<=3",E2:E7, "No")