COUNTIFS

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

Syntax

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

Arguments

Name	Type	Description
CriterionRange1	Range	The range of cells to count.
Criterion1	String	The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,... (optional)	Range	Additional cell-range which is checked against next criterion.
Criterion2,... (optional)	String	Additional criterion each cell of CriterionRange2 has to fulfill.

Return

Type	Description
Number	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.