Another Blank Cell Issue in Excel

• 1 min read

Excel has plenty of issues when it comes to correctly handling blank cells. Here is a solution to one of those issues.

In the image below the table on the left has some blank cells in column B. They are all coloured yellow.

The table on the right is using the COUNTIF function in column F to count the states and the number of blank cells.

Cell E10 is also blank but as you can see below, the formula in cell F10 is referring to cell E10 which is blank, but it doesn’t count the blank cells in column B.

The solution is to change cell E10 to.

=””

Two quotation marks together represent a blank cell in Excel.

The formula in cell F10 will then work correctly.