SUMIFS Practice Exercises
SUMIFS adds up numbers that meet one or more conditions. It's the single most common task on data analyst Excel screens.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Watch the order: in SUMIFS the sum range comes first. In SUMIF it comes last. Interviewers love this trap.
Practice
Useful criteria
- Greater than:
">5000" - Not equal:
"<>West" - From a cell:
">"&H1 - Wildcard:
"Wid*"
Test yourself under time: free 10-question Excel test →