Excel Function

AVERAGEIFS

Returns average for values matching multiple conditions.

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments

average_range

Required

Specify the range of values to average.

criteria_range1

Required

Specify the range to evaluate criteria1.

criteria1

Required

Enter the match condition for criteria1.

criteria_range2

Optional

Specify the range where criteria_range2 is evaluated.

criteria2

Optional

Enter the match condition for criteria2.

Practice Preview

calculate average sales for multiple conditions. Use AVERAGEIFS to Returns average for values matching multiple conditions. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. For criteria, enter a match condition such as "text condition", ">=number", or "<>blank". use "食品" for criteria1, use ">=1000" for criteria2. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=AVERAGEIFS(D2:D8, C2:C8, "食品", D2:D8, ">=1000")

Practice This Function

Practice in Sequential ModeBack to Function List