FormuladrillAVERAGEIFS practice
AVERAGEIFS averages the cells that meet several conditions at once. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)
What people get wrong
Unlike AVERAGEIF, the range to average comes first.
Excel exercise that use AVERAGEIFS
- Average with two conditionsLevel 2Pro
Practice AVERAGEIFS now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free