FormuladrillAVERAGEIF practice
AVERAGEIF averages the cells in a range that meet one condition. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
AVERAGEIF(range, criterion, [average_range])
What people get wrong
When no cell meets the condition the result is #DIV/0!, which is usually a sign to wrap it in IFERROR.
Excel exercise that use AVERAGEIF
- Average for one regionLevel 2Pro
Practice AVERAGEIF now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free