Counting with COUNTIFS
IntermediateAdvanced
12 questions, about 18 minutes
Count with several conditions at once, for example region and status.
What we'll do
- Combining several conditions
- Making the ranges the same size
What you'll use
COUNTIFS
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