Formula Functions > Functions A to C > 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.
COUNT | COUNTA | COUNTBLANK | SUMIF | Statistical Functions