Skip to content

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

Lesson 3/5

COUNTIF: count what matches

Exercise 1 of 3

In F2, count the orders from the North region.

About this lesson

COUNTIF counts the cells that match a value, such as all the orders from one region.

In this lesson

  1. In F2, count the orders from the North region.
  2. In F2, count the coffee orders.
  3. In F2, count the orders for the region typed in E2.

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.