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: