AVERAGEIF practice
AVERAGEIF averages the cells in a range that meet one condition. Below are the 1 Google Sheets exercise on Sheetsdrill 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.
Google Sheets exercise that use AVERAGEIF
Practice AVERAGEIF now
Your first 15 exercises are free without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free