Description Returns the number of cells within a range that meet the given criteria.
Syntax COUNTIF ( range, criteria )
| Argument | Description |
|---|---|
| range | Range of cells you want to count. |
| criteria | Number, expression, or text that defines which cells are counted. |
Example The following example uses this worksheet.
This function returns 4:
See Also AVERAGE, COUNTA, SUM, SUMIF
