BeginnerStatistical Functions
Count orders above a threshold with COUNTIF
Count how many rows meet a numeric condition.
COUNTIF
5 min15 points
COUNTIF practice exercises
Counts cells that meet one condition. Below are 3 interactive exercises that put it to work on realistic business data — you write the formula, and get told exactly what went wrong when it does not work.
Syntax
COUNTIF(range, criteria)
Practise COUNTIF
Ordered from most approachable to hardest.
- 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
When COUNTIF is the right tool
Counts cells that meet one condition. It belongs to the statistical functions family, and it shows up constantly in real work — which is why it is worth being genuinely fluent rather than merely familiar.
Before this one, it helps to be comfortable with COUNT. The exercises below assume that ground is covered.
Reading about a function is not the same as being able to write it. The exercises on this page exist because the gap between recognising COUNTIF and producing it from memory, correctly, on data you have not seen before, only closes by doing it.
Related functions
Questions about COUNTIF
How do I practise COUNTIF without Excel installed?
Every exercise on this page runs in your browser. You type the COUNTIF formula into a real spreadsheet grid and get told immediately whether it works — no download, no account.
What does COUNTIF do?
Counts cells that meet one condition. The syntax is COUNTIF(range, criteria). The exercises below put it to work on realistic business data rather than abstract examples.
How long does it take to learn COUNTIF?
Most people can write a working COUNTIF formula within twenty minutes of practice. Getting it right under pressure — with edge cases, unsorted data and ranges that must survive being filled down — is what the harder exercises here are for.