Practice challenge
Count missing customer emails
#21
3 attempts remaining
BeginnerCustomersTarget D2
A customer list marks missing email addresses as Missing.
Write a formula for D2 that counts cells marked "Missing" in the email status column.
Count missing customer emails
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Customer | Email status | Region | Missing count |
| 2 | River Co | Present | North | blank |
| 3 | North Ltd | Missing | West | blank |
| 4 | Blue Shop | Present | South | blank |
| 5 | Metro Inc | Missing | East | blank |