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 Value
The number of cells which meet all specified criteria.
Example
A | B | C | D | |
1 | 230000 | Freiburg | 3 | No |
2 | 197000 | Cologne | 2 | Yes |
3 | 345678 | Cologne | 4 | Yes |
4 | 321900 | Freiburg | 2 | Yes |
5 | 203000 | Cologne | 3 | No |
Function | 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. |