Hide them with blanks:

Say we are entering numbers in column A & B
In column C we have:

=A1+B1 and copied down. For rows that have no values in A or B, column C
shows 0. If we want C to be blank if either A or B is blank, then:

=IF(OR((A1=""),(B1="")),"",A1+B1)
--
Gary''s Student - gsnu200767


"Dobbin0_4" wrote:

I am seting up a spreadsheet that works like a bank statement, So from
ranges g 6 through g29 i have a balance figure. But i will be adding
transactions to this as i go along through the month. So in cell G7 i have
the formula:
=SUM(G8-F9+E9) and that is then dragged down so htat all the cells to g29
contain this formula.

However they all show the data in the cell above it i.e. cell g8 shows the
amount in g7 and so on. Is there a way to hide this data until i need to
fill the cell with new data?

I hope that you undertand the question its a bit drawn out, and maybe
confusing, if so i apologise.

Thanks in advance