COUNTIF
Counts the number of cells within a range that meet the given criteria.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
What it does
Counts cells that meet a single condition.
Syntax
COUNTIF(range, criteria)
Arguments
range(range) — Cells to evaluate.criteria(criteria) — Condition (e.g., ">0", "Yes").
Examples
Count a category
Count how many times "Food" appears in A2:A6.
FORMULA
=COUNTIF(A2:A6,"Food")
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Category |
| 2 | Food |
| 3 | Travel |
| 4 | Food |
| 5 | Other |
| 6 | Food |