Try something like this:

=IF(A10="","",SUM(.....))

--
Biff
Microsoft Excel MVP


"mp smith" wrote in message
...
In my "total" column I don't want the results of the SUM to show up if
there
is not an entry in the cell to the left of the SUM cell.
--
MPS