Lesson 13 · Conditional Math

SUMIF Function

Practice SUMIF in Google Sheets: add up values that match a condition, with or without a separate sum range.

Task 1 of 3

Total the sales for the East region. 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.

Adding values that meet a condition

=SUMIF(range, criterion, [sum_range])

SUMIF checks each cell in range against the criterion and adds up the matching rows from sum_range.

=SUMIF(B2:B11, "East", C2:C11) totals column C where column B says East.
If you leave out sum_range, SUMIF adds the matching cells in range itself: =SUMIF(B2:B11, ">1000").
Point the criterion at a cell (E2) to build a little report that updates when you change E2.

Criteria work exactly like COUNTIF: comparisons in quotes, wildcards allowed.