countif

Count cells in a range that meet a criterion.

Syntax

v = countif(range, criteria)

Description

Counts cells in range matching criteria. Criteria can be a number, string, or comparison expression like '>5', '<>0', 'apple*' (with wildcards).

Examples

countif(A1:A100, '>0')
countif(B1:B50, 'apple*')

See also

• countifs — Count cells meeting multiple criteria.
• count — Count numeric values in the arguments.
• averageif — Mean of numbers in a range that meet a criterion.
• sumif — Sum cells in a range that meet a criterion.