COUNTIF(list, condition)

Counts the the number of cells in a list matching a condition. For example:

COUNTIF(A1..A10, ">5")

returns a count of the number of cells having a value greater than 5. Note that the condition should be surrounded by quotes if it contains any non-numeric characters.

More examples:

Formula

Returns

COUNTIF({"Mon", "Tue", "Mon", "Thu"}, "Mon")

2

COUNTIF({5, 4, 5, 3, 5}, ">=4")

4

COUNTIF({5, 4, 5, 3, 5}, 5)

3

See also:

SUMIF(list, condition)

Other statistical functions