countif, blank if zero

  • Thread starter Thread starter eugene
  • Start date Start date
E

eugene

Hi,

When countif does not find any occurrences, it writes "0". Is there anyway
to change that so that it writes nothing - leaves a blank)?
 
=IF(COUNTIF([whatever])>0, COUNTIF([whatever]), "") should do the trick;
don't know if there's a more elegant way than that.
 
that was quick. thanks

--
eugene


Fay Roberts said:
=IF(COUNTIF([whatever])>0, COUNTIF([whatever]), "") should do the trick;
don't know if there's a more elegant way than that.

eugene said:
Hi,

When countif does not find any occurrences, it writes "0". Is there anyway
to change that so that it writes nothing - leaves a blank)?
Click to expand...
Click to expand...
 
You're welcome! I was about to post my own query and thought "Oooh, I know
the answer to *that* one...!"

F

eugene said:
that was quick. thanks

--
eugene


Fay Roberts said:
=IF(COUNTIF([whatever])>0, COUNTIF([whatever]), "") should do the trick;
don't know if there's a more elegant way than that.

eugene said:
Hi,

When countif does not find any occurrences, it writes "0". Is there anyway
to change that so that it writes nothing - leaves a blank)?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top