Use Excel COUNBLANK Function to count cells which are blank.
In simple words, when you specify a range of cells it will return the number of cells which have no value in it. And, if there is no blank cell in the range it will return “0”.
- range A range of cells from which you want to count blank cells.
More Information on Excel COUNTBLANK Function
- If there is a zero in a cell, that will consider as a non-blank cell, hence ignored.
- And, if a cell has a formula resulting in an empty (=” “), that will also consider as a non-blank cell.
- Cells contain numbers, text, errors & symbols are ignored.
In the below example, I have used COUNTBLANK function to count blank cells from the range A2:A8.
In this range, I have total 3 cells which are blank but cell A7 has a formula in it which results in a blank cell. The function has returned 2 as cell A4 & A5 are the only cells which are blank and have no values.
To learn more about excel MID function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.