Skip to content

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

Lesson 1/5

COUNT: count numbers

Exercise 1 of 3

Some students were absent. In E2, count how many scores were entered in B2:B9.

About this lesson

COUNT counts the cells that hold numbers, so you can see how many values were actually entered.

In this lesson

  1. Some students were absent. In E2, count how many scores were entered in B2:B9.
  2. COUNT(B2:B9) gives 5, but there are 8 students. Why?
  3. The thermometer broke on two days. In B10, count the days with a temperature in B2:B8.

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.