Formuladrill

Level 1: Basics Exercise 15 of 118

Missing timesheets

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Seven employees should have entered their hours. Count how many cells in B2:B8 are still empty and put the number in E2.

What this exercise teaches

COUNT counts numbers, COUNTA counts anything filled in and COUNTBLANK counts what is missing. On a list that should be complete, the blank count is the one to watch.

A hint if you get stuck

COUNTBLANK(range) counts the empty cells. Counting the rows and taking off COUNT of the filled cells works too.

Functions used: COUNTBLANK

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Basics