Thanks and countif !

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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.
 
.... or change the number format so that 0 is shown as "" or "-", etc.
(Format > Cells > Number tab, select Custom)
 
Back
Top