CrashMatRob
New Member
- Joined
- Mar 17, 2012
- Messages
- 26
- Office Version
- 2019
=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.
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.