using the countif function

H

harrimanxix

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
 
A

akphidelt

Just wrap the formula around in an If statement like

=If(Countif(yourrange,"D")=0,"",Countif(yourrange,"D"))
 
Top