Sheetsdrill

SUMIF practice

SUMIF adds the cells in a range that meet one condition. Below are the 2 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SUMIF(range, criterion, [sum_range])

What people get wrong

The range tested and the range summed are different arguments; mixing them up gives a plausible but wrong number.

Google Sheets exercises that use SUMIF

Practice SUMIF 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