Excel Function

COUNTIF

Counts cells matching a condition.

COUNTIF(range, criteria)

Arguments

range

Required

Specify the range used for condition check or aggregation.

criteria

Required

Enter the match condition, e.g. "Food", ">=80", "<>0".

Practice Preview

count rows that match a condition. Use COUNTIF to Counts cells matching a condition. 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 criteria. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=COUNTIF(C2:C8, "食品")

Practice This Function

Practice in Sequential Mode Back to Function List