Countif

**jamesryan** · 01-09-2009, 10:33 AM

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!!

**NBVC** · 01-09-2009, 10:40 AM

If you really have numbers and blanks in that column, then perhaps Count() would work.

=Count(B:B)

**DonkeyOte** · 01-09-2009, 10:46 AM

for text: =countif(b:b,"*?")

**jamesryan** · 01-09-2009, 10:48 AM

[QUOTE=jamesryan;2023940]
I have a list of formulas in column B which product a blank value i.e. =IF(A1=1,"","WRONG") etc
QUOTE]

Sorry for the confusion but i typed the formula wrong in the initial post, if the formula does not produce a blank ("") then it produces some text instead to the count function would not work.