AVERAGEIF and MAXIFS
AdvancedAdvanced
12 questions, about 18 minutes
The average or highest value within a group.
What we'll do
- An average with a condition
- The highest value within a group
What you'll use
AVERAGEIFMAXIFSAVERAGEMINIFSAVERAGEIFS
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