countif, blank if zero

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

 

[Fay Roberts]

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

 

[eugene]

that was quick. thanks

--
eugene

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

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

 

[Fay Roberts]

You're welcome! I was about to post my own query and thought "Oooh, I know
the answer to *that* one...!"

F

that was quick. thanks

--
eugene

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

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