COUNTIFS
StatisticalCOUNTIFS helps you perform summary and inferential functions for descriptive and statistical analysis.
Overview
Start with "=" then enter COUNTIFS(criteria_range1, criteria1, ...). Keep argument order as shown and use cell ranges where appropriate.
Backend scalar pathComplete docs
Syntax & Arity
=COUNTIFS(criteria_range1, criteria1, ...)
2+ arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| criteria_range1 | Required | Single | Range evaluated against a condition. |
| criteria1 | Required | Single | Condition used to include matching values. |
Example Inputs & Outputs
Formula
=COUNTIFS(<criteria_range1>, <criteria1>)
Example Output
Statistical summary value
Replace placeholders with your worksheet values or ranges to compute a result.