Skip to main content

COUNTIFS

Counts the number of cells within a range that meet multiple criteria.

Description​

Counts the number of cells within a range that meet multiple criteria.

Syntax​

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments​

  • criteria_range1: The first range in which to evaluate criteria.
  • criteria1: The first criteria in the form of a number, expression, cell reference, or text that defines which cells in criteria_range1 will be counted.
  • [criteria_range2, criteria2], ...: (Optional) Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.

Example​

COUNTIFS(A2:A9, ">=5", B2:B9, "<10") → Returns the number of cells in A2:A9 and B2:B9 where the corresponding value in A2:A9 is greater than or equal to 5, and the corresponding value in B2:B9 is less than 10.
COUNTIFS(A1:A10, "Apples", C1:C10, ">50") → Returns the number of cells where the corresponding value in A1:A10 is "Apples" and the corresponding value in C1:C10 is greater than 50.