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: