IntermediateStatistical Functions
Count orders meeting two conditions
Count rows that satisfy several criteria at once.
COUNTIFS
8 min25 points
COUNTIFS
Counts cells that meet several conditions at once.
Syntax
COUNTIFS(criteria_range1, criteria1, ...)
Statistical Functions.
Practise COUNTIFS4 interactive exercises, free, no account needed
A worked example
=COUNTIFS(C2:C9,"East",B2:B9,">2000")
Returns 3
Counts rows that are both in the East region and above $2,000.
Where it goes wrong
Every range must cover the same rows. Mismatched heights misalign the comparison silently rather than erroring.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- This counts every East order regardless of value. You need both conditions, which means COUNTIFS.Count orders meeting two conditions
- COUNTIF handles exactly one condition, so this counts every Columbus row regardless of status or size. Three conditions need the plural version.Count backorders on three conditions
- These exclude the boundaries themselves. The band was described as at least 1000 and at most 5000, so an order of exactly 1000 belongs in it.Count orders inside a value band
Practise COUNTIFS
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All COUNTIFS practice exercises →
- 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