Sheetsdrill

Level 2: Conditional counting and summing Exercise 35 of 92

Contacts with no email

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Count the contacts whose email cell in B2:B10 is empty. Answer in E1.

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. The number of contacts minus COUNTA of the emails gives the same result.

Functions used: COUNTBLANK

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill 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 Conditional counting and summing