How do I use this formula and add if 0,"" so the cells are blank rather than 0 =SUMIF(NotReady!AA17:AA50,5,NotReady!AB17:AB50)
I would like it in formula rather then cell format please
Thanks in advance!
How do I use this formula and add if 0,"" so the cells are blank rather than 0 =SUMIF(NotReady!AA17:AA50,5,NotReady!AB17:AB50) I would like it in formula rather then cell format please Thanks in advance! 


This can be easily achieved by a simple formula:



Let's call your formula
If x = 0 then return "", otherwise display value. The formula for this would be
So, replace the above x's in the formula with your formula to get


