SUMIFS practice

SUMIFS adds the cells that meet several conditions at once. Below are the 2 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)

What people get wrong

Unlike SUMIF, the range to add comes first. Dates work as criteria with ">="&start.

Google Sheets exercises that use SUMIFS

• Sales for one rep and monthLevel 2Pro
• Won deals above a minimumLevel 2Pro