How to turn cell blank if SUMIF, COUNTIF condition not met

[ash2017]

Hello,

Is there anyway I can turn the field blank if SUMIFS, COUNTIFS conditions not satisfied. I am using the below formulas which is working fine. But when the conditions not satisfied, I am getting 0. I wanted the field to be blank.

=SUMIFS(Data!$O$4:$O$1000,Data!$B$4:$B$1000,$G5&"*",Data!$M$4:$M$1000,"Y", Data!$K$4:$K$1000,">="&$B$2,Data!$K$4:$K$1000,"<="&$D$2)

=COUNTIFS(Data!$B$4:$B$1000,$G5&"*",Data!$G$4:$G$1000,$I$4&"*",Data!$K$4:$K$1000,">="&$B$2,Data!$K$4:$K$1000,"<="&$D$2,Data!$M$4:$M$1000,"*Y*")

Thank you,
Best regards

[FDibbins]

The long version...
=if(SUMIFS(Data!$O$4:$O$1000,Data!$B$4:$B$1000,$G5&"*",Data!$M$4:$M$1000,"Y", Data!$K$4:$K$1000,">="&$B$2,Data!$K$4:$K$1000,"<="&$D$2)=0,"",SUMIFS(Data!$O$4:$O$1000,Data!$B$4:$B$1000,$G5&"*",Data!$M$4:$M$1000,"Y", Data!$K$4:$K$1000,">="&$B$2,Data!$K$4:$K$1000,"<="&$D$2)

The short version - if there is something specific in those ranges/criteria that, if that is empty, all will be empty, then try this...
=if(your-selected-cell="","",SUMIFS(Data!$O$4:$O$1000,Data!$B$4:$B$1000,$G5&"*",Data!$M$4:$M$1000,"Y", Data!$K$4:$K$1000,">="&$B$2,Data!$K$4:$K$1000,"<="&$D$2))

[Phuocam]

Try:

=IFERROR(1/(1/"your formula"),"")

[ash2017]

Thanks Phuocam. I tried it and its working.