using the countif function

[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

 

[akphidelt]

Just wrap the formula around in an If statement like

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

 

[RagDyer]

One way:

=IF(COUNTIF(B1:B100,"D"),COUNTIF(B1:B100,"D"),"")