Are you sure that you are not clearing A21 with the delete key but hitting
the spacebar? Space looks blank, but is not.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Ian P" wrote in message
...
Has anybody encountered a problem with the countblank function? I am
using a
formula =if(a21="","",a21); =if(a22="","",a22) etc. I then use the
countblank function to count the number of blanks in this array. If I
delete
a21 then the formula delivers the blank cell but the countblank doesn't
increase. Weirdly, if I press delete a second time then the countblank
updates. I've checked the calculation options and everything seems to be
set
right so why would this happen?

Thanks

Ian

PS I know that it's easy to get round this by using other counts but I
wondered why the countblank function doesn't work properly.