make cell blank

[chris007]

Hello,
I have the following formula which works great thanks to guys here,
=COUNTIFS($C$9:$C$24,"Supply*",$K$9:$K$24,">=300") how can i have the cell be balnk if the result is "0"

I have tried ,"" I have tried If("") etc but does not want t play ball for me. currently if there are nil observations then the cell shows "0"

thanks
Chris007

 

[Trevor G]

What about custom format to hide 0.

0;-0;;

This came from this thread where Peter helped

http://www.mrexcel.com/forum/showpost.php?p=2861529&postcount=3

 

[repairman615]

Hello,

Have you tried like:

=IF(COUNTIFS($C$9:$C$24,"Supply*",$K$9:$K$24,">=300")=0,"",COUNTIFS($C$9:$C$24,"Supply*",$K$9:$K$24,">=300"))

 

[chris007]

Guys, thanks for your Help,
Works Well, the formula is long winded but think exactley what I was looking for

thanks Again
reagrds
Chris007