countif question

[xoxo]

Right now I have a code for counting numbers between 29 - 42.

=COUNTIF(B3:F3,">=29")-(COUNTIF(B3:F3,">42"))

Right now the code above gave me a 0, indicating there is no number between 29 - 42.

Is there another method to have no number show up at all, not even a 0 if there is no numbers between 29 - 42? I just want the cell leave it blank instead of putting a 0.

Thanks.

 

[hiker95]

Having a problem posting.

Try:

=IF(COUNTIF(B3:F3,">=29")-(COUNTIF(B3:F3,">42"))=0,"",COUNTIF(B3:F3,">=29")-(COUNTIF(B3:F3,">42")))

 

[Domenic]

Or, the cell can be custom formatted to hide zero values...

Format > Cell > Number > Custom > Type: 0;-0;;@

 

[xoxo]

Having a problem posting.

Try:

=IF(COUNTIF(B3:F3,">=29")-(COUNTIF(B3:F3,">42"))=0,"",COUNTIF(B3:F3,">=29")-(COUNTIF(B3:F3,">42")))

This is exactly what I am looking for! It works beautifully. Thank you.

 

[xoxo]

Or, the cell can be custom formatted to hide zero values...

Format > Cell > Number > Custom > Type: 0;-0;;@

Thank you for the help. It only hides it but it's still there. hiker95's code is what I am looking for.