View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fay Roberts Fay Roberts is offline
external usenet poster
 
Posts: 3
Default 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