BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 points
SUMIF practice exercises
Adds up only the values that meet one condition. Below are 7 interactive exercises that put it to work on realistic business data — you write the formula, and get told exactly what went wrong when it does not work.
Syntax
SUMIF(range, criteria, [sum_range])
Need a refresher? Learn SUMIF — syntax, a worked example and where it goes wrong.
Practise SUMIF
Ordered from most approachable to hardest.
- IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points - IntermediateData Analysis
Average one region without AVERAGEIF
Build a conditional average out of a conditional sum and a conditional count.
SUMIF · COUNTIF
9 min30 points - AdvancedData Analysis
Build a regional summary from raw orders
Produce a summary line combining count, total and average for one region.
COUNTIF · SUMIF
16 min40 points - IntermediateData Analysis
Total overtime hours for one team
Add up overtime for a single team out of a mixed timesheet.
SUMIF
7 min25 points - IntermediateData Analysis
Total marketing spend for one channel
Add up spend for a single channel out of a mixed campaign list.
SUMIF
7 min25 points - IntermediateData Analysis
Which range does SUMIFS want first?
Recall the argument order that differs between SUMIF and SUMIFS.
SUMIF · SUMIFS
3 min20 points
When SUMIF is the right tool
Adds up only the values that meet one condition. It belongs to the math functions family, and it shows up constantly in real work — which is why it is worth being genuinely fluent rather than merely familiar.
Before this one, it helps to be comfortable with SUM. The exercises below assume that ground is covered.
Reading about a function is not the same as being able to write it. The exercises on this page exist because the gap between recognising SUMIF and producing it from memory, correctly, on data you have not seen before, only closes by doing it.
Related functions
Questions about SUMIF
How do I practise SUMIF without Excel installed?
Every exercise on this page runs in your browser. You type the SUMIF formula into a real spreadsheet grid and get told immediately whether it works — no download, no account.
What does SUMIF do?
Adds up only the values that meet one condition. The syntax is SUMIF(range, criteria, [sum_range]). The exercises below put it to work on realistic business data rather than abstract examples.
How long does it take to learn SUMIF?
Most people can write a working SUMIF formula within twenty minutes of practice. Getting it right under pressure — with edge cases, unsorted data and ranges that must survive being filled down — is what the harder exercises here are for.