Course
COUNTA and COUNTBLANK practice exercises
Five exercises, from counting replies to finding the missing fields of every customer record. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Count the replies received
Column B shows each guest’s reply to an invitation, and some guests haven’t answered yet. In E2, count how many replies you have received with COUNTA.
| Guest | Reply | |||
| Olivia Reed | Yes | Replies received | ||
| James Carter | No | |||
| Sofia Patel | ||||
| Liam Brooks | Yes | |||
| Emma Hughes | Yes | |||
| Noah Bennett | ||||
| Ava Collins | No | |||
| Ethan Ward | Yes | |||
| Mia Foster | ||||
| Lucas Gray | Yes |