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.