FormuladrillCOUNTIFS practice
COUNTIFS counts the rows that meet several conditions at once. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2], ...)
What people get wrong
Every criteria range must be the same size, or the result is #VALUE!.
Excel exercise that use COUNTIFS
- Count with two conditionsLevel 2Pro
Practice COUNTIFS now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free