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.
=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.