Excel Function

SUMIFS

Sums values that meet multiple conditions.

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments

sum_range

Required

Specify the range of values to sum.

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

sum sales that match multiple conditions. Use SUMIFS to Sums values that meet 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

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

Practice This Function

Practice in Sequential ModeBack to Function List