IntermediateStatistical Functions
Count orders meeting two conditions
Count rows that satisfy several criteria at once.
COUNTIFS
8 min25 points
COUNTIFS practice exercises
Counts cells that meet several conditions at once. Below are 4 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
COUNTIFS(criteria_range1, criteria1, ...)
Need a refresher? Learn COUNTIFS — syntax, a worked example and where it goes wrong.
Practise COUNTIFS
Ordered from most approachable to hardest.
- IntermediateData Analysis
Count backorders on three conditions
Narrow a count with three criteria at once rather than filtering by hand.
COUNTIFS
8 min25 points - IntermediateData Analysis
Count orders inside a value band
Apply an upper and a lower bound to the same column at once.
COUNTIFS
7 min25 points - IntermediateData Analysis
Count staff overdue a review
Count people in one department whose last review was long enough ago.
COUNTIFS
8 min25 points
When COUNTIFS is the right tool
Counts cells that meet several conditions at once. 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 COUNTIF. 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 COUNTIFS and producing it from memory, correctly, on data you have not seen before, only closes by doing it.
Related functions
Questions about COUNTIFS
How do I practise COUNTIFS without Excel installed?
Every exercise on this page runs in your browser. You type the COUNTIFS formula into a real spreadsheet grid and get told immediately whether it works — no download, no account.
What does COUNTIFS do?
Counts cells that meet several conditions at once. The syntax is COUNTIFS(criteria_range1, criteria1, ...). The exercises below put it to work on realistic business data rather than abstract examples.
How long does it take to learn COUNTIFS?
Most people can write a working COUNTIFS 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.