Count blanks cells

Hi there,

Just wondering if anyone knows of a way to count blank cells on a sheet then place the result in the cell it was counted from. Assumeing it has a result itself.

In each cell I have have =IF(COUNTIF(A7:B7:C7:D7:E7:F7, "1")=1,"1"," "). This only gives me the result of '1' if the condition is true. Im looking to count how far between common results.

for example

+-----------+
| 1
+-----------+
|
+-----------+
|
+-----------+
|
+-----------+
|
+-----------+
| 4
+-----------+

I have had a look at COUNTBLANK but I don't think thats going to work for me.

Thanks!

Jason