COUNTIFS

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

Syntax

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

Arguments

Name	Description
CriterionRange1	The range of cells to count.
Criterion1	The 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

	A	B	C	D
1	230000	Freiburg	3	No
2	197000	Cologne	2	Yes
3	345678	Cologne	4	Yes
4	Freiburg	321900	2	Yes
5	Cologne	203000	3	No

Formula	Result	Comment
COUNTIFS(C1:C4, ">=3")	3	Counts all houses which have three or more rooms.
COUNTIFS(B1:B5, "Cologne", D1:D5, "=Yes")	2	Counts all houses in Cologne which have a garage.