Hi
do you mean something like
=IF(SUM(A1:X1)=0,"",SUM(A1:X1))

For formatting check 'Format - Cells - Currency

--
Regards
Frank Kabel
Frankfurt, Germany

"charliefortune" schrieb im
Newsbeitrag ...
I want to keep a running total in a balance column, so I have
formulae adding
the profit and loss for the day, then adding this to the previous
days total.
It works, but it starts by filling the column with zeros. Each value
I add,
fills the rest of the column with the current total. The sums are all
correct, but I dont like the look of it. I want to leave the cells
empty
until something changes.

I also would like to display negative values in red.

Thanks...