Skip to content
Lesson 5/5

COUNTIFS: several conditions

Exercise 1 of 3

In F2, count the tea orders from the North region.

About this lesson

COUNTIFS counts the rows that meet several conditions at once.

In this lesson

  1. In F2, count the tea orders from the North region.
  2. In F2, count the tea orders with an amount over 40.
  3. In F2, count the orders with an amount from 30 to 60, 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.