Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 2/4

FILTER: rows that match

Exercise 1 of 3

In E2, list the amounts of all North orders.

About this lesson

FILTER returns every row that matches a condition, as a list that updates with the data.

In this lesson

  1. In E2, list the amounts of all North orders.
  2. In E2, list the whole rows of orders with an amount of 60 or more.
  3. In E2, list the West amounts. There are none, so show "none" instead of an error.

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.