Counting blanks with COUNTBLANK
1 / 5
Some sign-ups have gaps. In row 10, count how many cells are empty in each column.
keyboard Typing formulas is easiest on a computer with a keyboard.
A1
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Phone | Paid | ||
| 2 | Tariq Li | tariq.li@example.com | 07700 900923 | ||
| 3 | Nadia Patel | nadia.patel@example.com | 07700 900918 | 25 | |
| 4 | Daniel Fischer | ||||
| 5 | Quinn Evans | 07700 900039 | 25 | ||
| 6 | Jamal Novak | jamal.novak@example.com | |||
| 7 | Isla Kowalski | 07700 900510 | 25 | ||
| 8 | Kofi Patel | kofi.patel@example.com | 10 | ||
| 9 | Yusuf Dubois | yusuf.dubois@example.com | 07700 900676 | ||
| 10 | Missing | ||||
| 11 | |||||
| 12 | |||||
| 13 | |||||
| 14 |
details
missing
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
How COUNTBLANK and COUNTA works
What does
COUNTBLANKdo?COUNTBLANKcounts the empty cells in a range:=COUNTBLANK(B2:B9).How is it different from
COUNTA?COUNTAcounts the cells that are filled in;COUNTBLANKcounts the ones that aren't. Together they add up to the number of cells in the range.What counts as blank?
A cell with nothing in it. A cell holding a space looks empty but isn't, so
COUNTBLANKdoesn't count it.
Know someone fighting with a spreadsheet? Send them this page.