Countif
 

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.

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


"nc" wrote in message
...
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.

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)


"nc" wrote in message
...
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.

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)


"nc" wrote in
message
...
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.


.