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 | [email protected] | Emails | |||
| 3 | Ben | |||||
| 4 | Cara | [email protected] | ||||
| 5 | Dan | |||||
| 6 | Eva | [email protected] | ||||
| 7 | Finn | [email protected] | ||||
| 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