Counting with COUNTIF
IntermediateBeginner
12 questions, about 17 minutes
Count only the rows that meet a condition.
What we'll do
- Counting with a text condition
- Counting with greater than and less than
- Using quotation marks correctly
What you'll use
COUNTIFCOUNTA
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
12questionsYou do it yourself