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(D50,(IF(ISBLANK(L5)=TRUE,"bob","")),"")
This formula works fine but i have a suspicion it affects the countif.
Any suggestions??
Thanks,
Chris
--
chris100
------------------------------------------------------------------------
chris100's Profile:
http://www.excelforum.com/member.php...o&userid=25166
View this thread:
http://www.excelforum.com/showthread...hreadid=490689