Hello all,

Small prolem with Countif. I have a function that counts if a cell is not blank - i.e has text in it:

=countif(v2:v200,"bob")

For some reason even if text is there it doesn't get counted.
Now the formula for cells where "bob" might appear is below:

=IF(D5>0,(IF(ISBLANK(L5)=TRUE,"bob","")),"")

This formula works fine but i have a suspicion it affects the countif.

Any suggestions??

Thanks,

Chris