Skip to content

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

Lesson 2/5

COUNTA and COUNTBLANK

Exercise 1 of 4

In E2, count how many students are on the list in A2:A9.

About this lesson

COUNTA counts every cell that isn't empty, and COUNTBLANK counts the empty ones.

In this lesson

  1. In E2, count how many students are on the list in A2:A9.
  2. In E2, count how many results were recorded in B2:B9, including "absent".
  3. In E2, count the students with no result yet in B2:B9.
  4. COUNTA(B2:B9) gives 7 and COUNT(B2:B9) gives 5. What are the 2 extra cells?

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.