Thanks and countif !

[Dave]

Hi,

Thanks everyone for all the help.

Just wondering - I have a countif function that returns a number - however,
to make it easier to read it would be good if the total is 0, then just an
empty cell is displayed.

Is this possible?

Thanks again

 

[Bob Phillips]

Dave,

Two ways

Test for it
=IF(COUNTIF(A1:A100,"Car")=0,"",COUNTIF(A1:A100,"Car"))

or use conditional formatting, setting the condition equal to 0 and set the
font to white.

 

[SB]

.... or change the number format so that 0 is shown as "" or "-", etc.
(Format > Cells > Number tab, select Custom)