When COUNTIF returns a "0" qty. show cell as blank
I am using this formula to count how many cells in a row have their checkbox checked, and it is working correctly. When the total = 0, I would like for the cell to appear blank instead of showing 0. I have tried nesting with an IF but I can't seem to get it to work.
=COUNTIF(Manufacturer@row:[Asset Tag #]@row, 0)
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!