using the countif function
Just wrap the formula around in an If statement like
=If(Countif(yourrange,"D")=0,"",Countif(yourrange, "D"))
"harrimanxix" wrote:
Hi All
im using the countif function to add up all the cells in a range that
contain the Letter D the formula works but the problem im having is that if
there is on D in the range then the formula returns the 0 (zero) value how do
i get it to just leave the cell blank ??? ps ive tries addin ,"") this does
not work
cheers guys or gals
|