⌨ Syntax
COUNTIFS(criteria_range1,criteria1,[criteria_range2,criteria2]…)
Arguments
criteria_range1
(required)
— The first range in which to evaluate the associated criteria.
criteria1
(required)
— The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".
▶ Examples
=COUNTIFS(B2:D2,"=Yes")
=COUNTIFS(A2:A7,"<6",A2:A7,">1")
=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")