Countif

N

nc

Hi

I have these formulas in the following cells,

F100 (=IF(ISBLANK('New Conference Office Sheet'!
B24),"",'New Conference Office Sheet'!B24))

T100 (=COUNTIF($F$99:F100,"<>"""))


Why is the Countif function including F100 in the count
when it returns a value of "" ?

Thanks.
 
J

Jim May

I suppose it is returning F100 because F100 is Not Empty.
Try
T100 =COUNTIF($F$99:F100,">"&0)
HTH
 
B

Bob Phillips

Because the cell is not empty. Having no value is not the same.

You could try

=SUMPRODUCT(--(LEN($F$99:F100)>0))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
N

nc

Thanks that works.

-----Original Message-----
Because the cell is not empty. Having no value is not the same.

You could try

=SUMPRODUCT(--(LEN($F$99:F100)>0))

--

HTH

RP
(remove nothere from the email address if mailing direct)





.
Click to expand...
 
Top