Count blank cells in a range and contiguous blank cells also as single cells! Tricky One!

Hello to all the Excel users and developers there:

I have a tricky need in Excel, which I haven't been able to solve. I think it's quite complicated and I don't have enough knowledge about VBA codes. . I would really appreciate if you could help me with this.!!!!!!

Basically what I'd like to do is to create a function. The input would be a RANGE with blank cells, and non blank cells. I would expect the function to COUNT 'SINGLE BLANK CELLS' as single "ranges" and CONTIGUOUS BLANK CELLS as single ranges too. I know it's kind of tricky, but in this Excel file I explained in a more detailed way what I want to do!!! Please!!!

Thanks a lot!!!

https://www.youtube.com/watch?v=QGS8DBcA5HA I made a video!!! :

OMG!!!! it works!!!!!!!! You're a genious. Thanks a lot sir!!!! How can I give you 5 stars or rate you!!!!!????????

Thanks sir!!!! Thanks a lot!!!!!! :o