Skip to main content
Version: Streamsheets 2.5

COUNTIF

Returns the number of cells in a cell-range which meet a given criterion. To specify multiple criteria please use COUNTIFS.

Syntax

=COUNTIF(CellRange, Criterion)

Arguments

NameDescription
CellRangeThe range of cells to count.
CriterionThe criterion a cell has to fulfill in order to be counted.

Return

The number of cells which meet criterion.

Examples

AB
1apples32
2oranges54
3peaches75
4apples86
FormulaResultComment
COUNTIF([object Object], [object Object])
2Counts all apples.
COUNTIF([object Object], [object Object])
2Counts all cells which values is greater than 55.