COUNTIF
Name
Countif
Description
Returns the number of cells that meet a certain condition.
Syntax
COUNTIF(cellrange,condition
This function has the following arguments:
| Argument | Description |
|---|---|
| cellrange | Range of cells to count; cell range reference |
| condition | Condition that determines which cells are counted, as text, number, or expression |
Data Type
Accepts cell range references. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
COUNTIF(A1:G5,"test")
COUNTIF(R6C3:R9C4,"<2")