Assuming your range to sum is A1:A10 then

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

This will leave the cell blank until data is entered in the range.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=505450