Skip to main content

COUNTIF

Counts cells that meet a criteria.

CategoryAggregate
SyntaxCOUNTIF(range, criteria)

Parameters

ParameterRequiredDescription
rangeRequiredThe range of cells to count.
criteriaRequiredThe criteria in the form of a number, expression, or text that defines which cells will be counted.

Example

COUNTIF(A1:A10, ">0")         // Count positive values

Auto-generated from the EngCanvas function registry.