COUNTIF

This function returns the number of cells that meet a certain condition.

COUNTIF(cellrange,condition)

This function has these arguments:

Argument	Description
cellrange	Range of cells to count; cell range reference
condition	Condition that determines which cells are counted, as a text, number, or expression (where expressions use the relational operators detailed in Operators in a Formula)

Accepts cell range reference. Returns numeric data.

COUNTIF(A1:G5,"test")

COUNTIF(R6C3:R9C4,"<2")

This function is available in product version 2.0 or later.