COUNTIFS function
Summary
Counts the number of cells within a range that meet multiple criteria
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
The COUNTIFS function syntax has the following 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".
criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.
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".
criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.
Example
=COUNTIFS(B2:D2,"=Yes")
=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
=COUNTIFS(B5:D5,"=Yes",B3:D3,"=Yes")
=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
=COUNTIFS(B5:D5,"=Yes",B3:D3,"=Yes")