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! 


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



This can be easily achieved by a simple formula:


