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","
"). 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


--
jmumby
------------------------------------------------------------------------
jmumby's Profile: http://www.excelforum.com/member.php...o&userid=34193
View this thread: http://www.excelforum.com/showthread...hreadid=539582