Thanks and countif !

D

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
 
B

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.
 
S

SB

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