Skip to content
Lesson 2/4

SUMIF: add up what matches

Exercise 1 of 3

In E2, add up the amounts for the North region only.

About this lesson

SUMIF adds only the rows that match a condition, such as one region or the amounts above a limit.

In this lesson

  1. In E2, add up the amounts for the North region only.
  2. In E2, add up only the amounts greater than 100.
  3. D2 holds a region. In E2, add up the amounts for whatever region is in D2.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in E2 and press Enter to check.