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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple arguments 3
Newbie Help - IF Yes No Function 0
countifs Function not giving desired result with date criteria 2
Excel Countif Function - Calculating Between Two Sets of Values 3
COUNTIFS using multiple named ranges in the criteria 0
Countif gone wrong 2
Needs help combining functions. 3
Excel - Wich Function should I use? 1

Top