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

Name	Type	Description
CellRange	Range	The range of cells to count.
Criterion	String	The criterion a cell has to fulfill in order to be counted.

Return

Type	Description
Number	The number of cells which meet criterion.

Examples

	A	B
1	apples	32
2	oranges	54
3	peaches	75
4	apples	86

Formula	Result	Comment
=COUNTIF(A1:A4, "apples")	2	Counts all apples.
=COUNTIF(B1:B4, ">55")	2	Counts all cells which values is greater than 55.