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”.
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.