countif, blank if zero

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)?
 
F

Fay Roberts

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

eugene

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

Fay Roberts

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