How to convert practically blank but theoretically nonblank cells to blank cells ["" cell]

During my calculations I used a formula like this to get rid of errors:

Please Login or Register  to view this content.

These caused me many "" cells.

Now I have to count non-blank cells but "" cells are behaved as non-blank cells as well.

Could you help me how to convert "" cells into totally blank cells?


Extra: Could you teach me, how to use iferror function as leave it blank if there is an error

Hi there,

To get the amount of non-blank cells in a range with "" values as blanks, you could try something like (with A1:A50 as the range):

=COUNTA(A1:A50)-COUNTBLANK(A1:A50)

HTH,

FermentedR

Your solution didn't help me that much but I never thought about =COUNTBLANK formula. Interestingly, when we have a cell of value ="" in A1:
=COUNTBLANK(A1) gives 1
=ISBLANK(A1) gives FALSE

This is ridiculous in my opinion. Then I used =COUNTIF(A1;"") this formula counts both "" cells and totally blank cells.