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
- Spend for one categoryLevel 2
- Everything except one statusLevel 2
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