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

[SebastianColombia]

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 I made a video.

https://www.youtube.com/watch?v=QGS8DBcA5HA&feature=youtu.be

Thanks a lot.

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​
2​	2​			4​
3​
4​	jad
5​
6​
7​
8​	nad
9​	8​
10​
11​	5​
12​	3​
13​
14​
15​	6​

D1, control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(A2:A15="",ROW(A2:A15)),IF(1-(A2:A15=""),ROW(A2:A15))),1))

 

[SebastianColombia]

Thank you very much sir!!! Does this work just for rows???

Thanks a lot!!

 

[Aladin Akyurek]

Thank you very much sir!!! Does this work just for rows???

Thanks a lot!!

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(A2:Z2="",COLUMN(A2:Z2)),IF(1-(A2:Z2=""),Column(A2:Z2))),1))

should also work, if this is what you meant...