Maybe something like this:

=IF(COUNT(A1:D1),SUM(A1:D1),"")

--
Biff
Microsoft Excel MVP


"Sally" wrote:

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?