FUNCTION CATALOGUE / STATISTICAL
COUNTIFS Excel function
Counts cells or rows matching multiple conditions.
Correct sentence to use
Count rows where [condition 1] and [condition 2].
Modify this query in PlainFormula →Example formula
=COUNTIFS(B:B,"London",C:C,">100")
Counts records meeting all criteria.
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)
Argument signature: criteria_range1, criteria1, [criteria_range2, criteria2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.