Sumifs Function

[CrashMatRob]

=SUMIFS($B$4:$B$200,$A$4:$A$200,BI3)

Hi,
I have the above Sumifs function which works the way it should,
but if it returns a value of zero "0", can I get the cell to show nothing?

I have tried using the formula below which dos not work.
=SUMIFS($B$4:$B$200,$A$4:$A$200,"",BI3,"")

Thank you.

 

[jasonb75]

You can hide a zero result by forcing an error to occur

=IFERROR(1/(1/SUMIFS($B$4:$B$200,$A$4:$A$200,BI3)),"")

 

[mohadin]

Missed something

 

[CrashMatRob]

You can hide a zero result by forcing an error to occur

=IFERROR(1/(1/SUMIFS($B$4:$B$200,$A$4:$A$200,BI3)),"")

Thank you, it now works as I would like.

 

[CrashMatRob]

You can hide a zero result by forcing an error to occur

=IFERROR(1/(1/SUMIFS($B$4:$B$200,$A$4:$A$200,BI3)),"")

Thank you, it now works as I would like.