Just check the SUM first...

=IF(SUM(CellsToBeSummed)0,SUM(CellsToBeSummed),"" )

--
Rick (MVP - Excel)


"topdog5564" wrote in message
...
I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0