ANALYSIS
SUMIF & SUMIFS
Sum values only for rows that meet criteria.
After this lessonCreate conditional totals without a pivot table.
How it works
SUMIF applies one condition. SUMIFS supports several conditions and places the sum range first.
Make sure every criteria range aligns row-for-row with the sum range; mismatched ranges are a common source of incorrect totals.
REAL WORK
Sum open quantity for one supplier or total consumption for one material and month.
SYNTAX
The pattern
=SUMIF(criteria_range, criteria, sum_range)
=SUMIFS(sum_range, range1, criteria1, ...)Example
=SUMIF(D2:D6,"Alpha",B2:B6)TRY IT
Test the formula
The sample sheet is local to this page. Change the formula and see the result immediately.
Result
QUICK CHECK
In SUMIFS, which argument comes first?
Progress is stored only in this browser. No account required.