How can you clear a cell in a formula? I want something similar to:

IF(<SomeCondition,"Text","")

But if I use that, and then try to count non-blank cells, the cells where "" was stored are not considered blank. How can I actually make the cell blank in that formula? Thanks.

Jerry