COUNTIF
StatisticalCOUNTIF helps you perform summary and inferential functions for descriptive and statistical analysis.
Overview
Start with "=" then enter COUNTIF(range, criteria). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=COUNTIF(range, criteria)
2 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| range | Required | Single | Cell range used as function input. |
| criteria | Required | Single | Condition used to include matching values. |
Example Inputs & Outputs
Formula
=COUNTIF(A1:A10,">=5")
Example Output
6
Counts values in range that satisfy the condition.