Lesson 14 · Conditional Math

SUMIFS Function

Practice SUMIFS in Google Sheets: sum values that meet two or more conditions. Interactive exercises.

Task 1 of 2

How many Monitor units were sold in the West? Answer in E2.

Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.

Summing with multiple conditions

=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

SUMIFS adds the cells in sum_range for rows where every condition is met.

Heads-up: the argument order is different from SUMIF. In SUMIFS the sum range comes first. This trips up nearly everyone at least once.

=SUMIF(criteria_range, criterion, sum_range)
=SUMIFS(sum_range, criteria_range, criterion, ...)

The sum range can also be a criteria range, e.g. "paid invoices of $500 or more".