SUMIF practice

SUMIF adds the cells in a range that meet one condition. Below are the 3 Excel exercises on Formuladrill 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.

Excel exercises that use SUMIF

• Sales for one regionLevel 2Pro
• Sales by region with messy labelsLevel 6Pro
• A region total that misses a rowLevel 7Pro

Often used together with: PROPER, TRIM