Hi,

I have a list of formulas in column B which product a blank value i.e. =IF(A1=1,"",1) etc

I want to count the number of non-blank cells however the following formula does no work: =COUNTIF(B:B,"<>"&"") or any similar variation of it.

The only way i can get around this is do : =65536-COUNTIF(B:B,"")

However i know this is only a workaround and not the real solution though!!