Excel Function

COUNTIFS

Counts cells matching multiple conditions.

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments

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

count rows that match multiple conditions. Use COUNTIFS to Counts cells 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

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

Practice This Function

Practice in Sequential Mode Back to Function List