Count cells that meet several conditions at the same time.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)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")Result: 12
Counts open items owned by Alice.
Yes — apply two conditions to the same column, e.g. ">=10" and "<=20", to count within a range.