CountIf

Syntax

CountIf(Range, Criteria)

Parameters

Range. The range of checked cells.

Criteria. The condition that determines, which cells must be taken into account. The condition may be a number, expression, cell reference, text, or function.

NOTE. All text conditions and conditions with logical mathematical characters must be enclosed in double quotation marks (").

Description

It returns the number of cells that satisfy the specified condition.

Example

Formula	Result	Description
=CountIf(B0:B3, ">0")	2	The number of cells in the B0:B3 range provided that cell values are positive. This range contains the following numbers: -6, 4, -9, 5.