only show updated values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Hi
do you mean something like
=IF(SUM(A1:X1)=0,"",SUM(A1:X1))

For formatting check 'Format - Cells - Currency
 
Back
Top