Making countif function produce blanks as opposed to 0's

[njw499]

I am using a countifs function to count items for me. Is there a way to make the output produce a blank as opposed to a 0? Any help much appreciated

[Pete_UK]

One way is to use this arrangement:

=IF(your_formula = 0,"",your_formula)

However, a quicker way is just to apply a custom format to the cell, using this string:

0;;

This causes zero to appear as a blank.

There are other ways ...

Hope this helps.

Pete

[benishiryo]

welcome to the forum, njw499. the 1 other way is if your COUNTIF is:
=COUNTIF(A:A,"abc")

then:
=IFERROR(1/(1/COUNTIF(A:A,"abc")),"")

the red part is where you should put in your formula

[Pete_UK]

Another way is to use conditional formatting to set the foreground colour to white (on a white background) if the cell value is zero.

Hope this helps.

Pete

[vlady]

custom format also??

[=0]"";General