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	Description
CellRange	The range of cells to count.
Criterion	The criterion a cell has to fulfill in order to be counted.

Return

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.