Skip to main content

COUNTIFS

Counts cells that meet multiple criteria across multiple ranges.

CategoryAggregate
SyntaxCOUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Parameters

ParameterRequiredDescription
criteria_range1RequiredThe first range to evaluate.
criteria1RequiredThe criteria to apply to criteria_range1.
criteria_range2OptionalAdditional range to evaluate.
criteria2OptionalCriteria to apply to criteria_range2.

Example

COUNTIFS(range, criteria)

Auto-generated from the EngCanvas function registry.