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.
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.
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 →