BeginnerStatistical Functions
Count orders above a threshold with COUNTIF
Count how many rows meet a numeric condition.
COUNTIF
5 min15 points
COUNTIF
Counts cells that meet one condition.
Syntax
COUNTIF(range, criteria)
Statistical Functions.
A worked example
=COUNTIF(C2:C9,">2000")
Returns 4
Counts how many of the eight orders cleared the $2,000 free-freight threshold.
Where it goes wrong
The condition must be a text string when it contains an operator. Writing >2000 without quotes is a syntax error.
Practise COUNTIF
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All COUNTIF practice exercises →
- AdvancedData Analysis
Build a regional summary from raw orders
Produce a summary line combining count, total and average for one region.
COUNTIF · SUMIF
16 min40 points - AdvancedData Cleaning
Find which customers are missing from a list
Use COUNTIF to reconcile two lists and spot what is absent.
COUNTIF · IF
14 min40 points