Sheetsdrill

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