Count cells that meet several conditions at the same time.
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)Arguments
criteria_range1required
The first range to test.
criteria1required
The first condition.
criteria_range2…optional
Additional range/criteria pairs.
COUNTIFS counts rows that satisfy every condition — for instance, open tickets assigned to one owner. Each criteria range must be the same size.
=COUNTIFS(B2:B100, "Open", C2:C100, "Alice")→12Counts open items owned by Alice.
Pair ranges and conditions
Supply each criteria range immediately followed by its condition.
Match range sizes
All ranges must cover the same rows.
Yes — apply two conditions to the same column, e.g. ">=10" and "<=20", to count within a range.