Counting Blank and Non-Blank cells
<p>I would like to count all the blank and non-blank cells in a given range of data only until the cell with a data. But I also have a limited to refer on only, its from <code>O4:O18</code>. </p>

<p><a href="https://i.stack.imgur.com/FdN5p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FdN5p.png" alt="sample2"></a> <a href="https://i.stack.imgur.com/kiRQY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kiRQY.png" alt="sample3"></a></p>

<p>Given from the sample above, I only have to count blank cells from Row4 to the cell with data which is <code>asd</code>. Any help? Thanks!</p>

<p>The use of count is to count the blank cells within the non-blank cells. lets say that the last row with data is 15, so 15 will be the last row with data and from row 4 to row 15, will count the blank cells in the Range.</p>