Skip to content

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

Lesson 4/5

COUNTIF with comparisons

Exercise 1 of 3

In F2, count the orders with an amount over 50.

About this lesson

Conditions in COUNTIF can compare as well as match: count the values over or under a limit.

In this lesson

  1. In F2, count the orders with an amount over 50.
  2. In F2, count the orders with an amount of 40 or less.
  3. In F2, count the orders with an amount of at least the minimum 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.