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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
NA() and COUNTIF functions together? 1
If and Countif 2
countifs Function not giving desired result with date criteria 2
If with countif or counta 3
Countif gone wrong 2
CountIf with And 0
Combine Sumif and Countif 3

Back
Top