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
|