countif, blank if zero
 

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

--
eugene

countif, blank if zero
 

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

"eugene" wrote:

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

--
eugene

countif, blank if zero
 

that was quick. thanks

--
eugene


"Fay Roberts" wrote:

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

"eugene" wrote:

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

--
eugene

countif, blank if zero
 

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

F

"eugene" wrote:

that was quick. thanks

--
eugene


"Fay Roberts" wrote:

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

"eugene" wrote:

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

--
eugene