AVERAGEIFS practice

AVERAGEIFS averages the cells that meet several conditions at once. Below are the 1 Google Sheets exercise on Sheetsdrill 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.

Google Sheets exercise that use AVERAGEIFS

• Average reply timeLevel 2Pro