Skip to main content
Version: Streamsheets 2.5

COUNTIFS

Returns the number of cells from several cell-ranges which meet all corresponding criteria.

Syntax

=COUNTIFS(CriterionRange1, Criterion1, [CriterionRange2,...], [Criterion2,...])

Arguments

NameDescription
CriterionRange1The range of cells to count.
Criterion1The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,... (optional)Additional cell-range which is checked against next criterion.
Criterion2,... (optional)Additional criterion each cell of CriterionRange2 has to fulfill.

Return

The number of cells which meet all specified criteria.

Examples

ABCD
1230000Freiburg3No
2197000Cologne2Yes
3345678Cologne4Yes
4Freiburg3219002Yes
5Cologne2030003No
FormulaResultComment
COUNTIFS([object Object], [object Object])
3Counts all houses which have three or more rooms.
COUNTIFS([object Object], [object Object], [object Object], [object Object])
2Counts all houses in Cologne which have a garage.