Skip to content
Lesson 3/4

SUMIFS: several conditions

Exercise 1 of 2

In F2, add up the amounts for tea sold in the North.

About this lesson

SUMIFS adds the rows that match several conditions at once, for example one product in one region.

In this lesson

  1. In F2, add up the amounts for tea sold in the North.
  2. In F2, add up the amounts from 50 to 100, including both.

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 F2 and press Enter to check.