to the best of my knowledge, I have not had a cell end up with Char(32) or
Char(160) thanks for bringing this up.

"Harlan Grove" wrote:

bj wrote...
I would recommend
=if(countblanks(A1:BJ1)0,"",your equation)
I like count blanks because CountA and Isblank both classify "" as filled.
....

But that begs the question whether the OP wants to treat cells
evaluating to "" the same as truly blank cells. On the grounds that
cells evaluating to "" *APPEAR* blank, what about cells evaluating to
sequences of CHAR(32) and/or CHAR(160) and nothing else? They'd also
*APPEAR* blank.