What does it do?
The Excel COUNTBLANK function very simply counts the number of empty cells in a range. Empty cells are literally cells with nothing in them. It’s worth noting an empty output from a formula in a cell will also be counted as BLANK.
Syntax Explained
![Excel COUNTBLANK function in the formula bar showing syntax.](https://axtellisolutions.files.wordpress.com/2020/03/countblank01.png?w=187&resize=187%2C67)
Range: This is the range of cells to count that are empty.
Examples
1. COUNTBLANK covering all types
![Example of an Excel COUNTBLANK function showing some cells filled with number or text string.](https://axtellisolutions.files.wordpress.com/2020/03/countblank02-1.png?w=722&resize=640%2C324)
The above screen shot demonstrates various types of ways a cell can be filled, or not.
The rows below are ALL deemed to be NOT BLANK when using the COUNTBLANK function:
Row 3 – Filled with a text.
Row 4 – Filled with a number (note this can be ANY number i.e. Date, whole number, fraction etc).
Row 5 – A cell containing a SPACE, not visually obvious, so I underlined it in my example.
Row 9 – A formula populating a result into a cell
Row 10 – As above but an error result
The rows below are ALL deemed to be BLANK when using the COUNTBLANK function:
Row 6 – A formula that outputs empty result, show by the red double quotes.
Row 7 – An actual empty cell, filled with nothing more than, well, nothing!
Row 8 – See above