FUNCTION CATALOGUE / STATISTICAL
COUNTIF Excel function
Counts cells matching one condition.
Correct sentence to use
Count cells in [range] where the value equals [value].
Modify this query in PlainFormula →Example formula
=COUNTIF(B:B,"London")
Counts cells matching a criterion.
Syntax
COUNTIF(range, criteria)
Argument signature: range, criteria
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.