Applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

COUNTIFS takes 2 required arguments and 126 optional arguments:

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

The arguments for the COUNTIFS function are:
Argument Required? Description
criteria_range1, criteria_range2, ... Required The range in which to evaluate the associated criteria. Criteria_range1 is required. Subsequent criteria_ranges are optional. Up to 126 additional criteria ranges.
criteria1, criteria2, ... Required The criteria in the form of a number, expression, cell reference, or text that define which cells in the Criteria_range argument will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32." Criteria1 is required. Subsequent criterias are optional. Up to 126 additional criterias.
comments powered by Disqus