Count filled-in cells with COUNTA
In E2, use COUNTA to count how many people in B2:B7 have given an email address.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Name | |||||
| 2 | Anna | anna@example.com | Emails | |||
| 3 | Ben | |||||
| 4 | Cara | cara@example.com | ||||
| 5 | Dan | |||||
| 6 | Eva | eva@example.com | ||||
| 7 | Finn | finn@example.com | ||||
| 8 |
Need help?
Why this works
COUNTA counts every cell that is not empty: text, numbers, dates and errors. The two people without an email leave blank cells, so the answer is 4.
Common mistake: Using COUNT here. Email addresses are text, so COUNT gives 0.
The answer
- E2
=COUNTA(B2:B7)
+10 points