only show updated values

C

charliefortune

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...
 
F

Frank Kabel

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

For formatting check 'Format - Cells - Currency
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top