If you want cells to be blank when a formula = 0 you can change a setting in
Excel 2007, just select Excel OptionsAdvanced and uncheck the "Show a Zero
in Cells That Have Zero Value" checkbox. If you have Excel 2003 I think its
under EditOptions or ToolsOptions, I can't remember.

If you just want that particular cell to be blank when its summed to 0 then
use Rick's or FSt1's formula.

Hope this helps! If so, click "YES" below.
--
Cheers,
Ryan


"topdog5564" wrote:

I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0