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.
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 exerciseMore exercises in Conditional counting and summing
- Spend for one category
- Late deliveries
- Open high-priority tickets
- Sales for one rep and month
- Won deals above a minimum
- Average reply time
- Largest order in a region
- Cheapest item in stock
- Orders between two dates
- Customer tiers with IFS
- Region names with SWITCH
- Contacts on one email domain
- Active SKUs with a prefix
- Free shipping rule
- Weighted average score
- Rank without RANK
- Everything except one status
- Revenue for one month
- Average rating without the zeros