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.
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