Quote Originally Posted by Simon
I am new to excel. I have been creating a spreadsheet to keep track of my
money.
On one sheet called Bill Money I have these column heads
DATE DETAILS IN OUT TOTAL
In the total column i have a formula that takes the previous TOTAL - OUT +
IN = TOTAL. I have copied all the formula down the total column but what
happens is the last total i have is displyed all the way to the last row. Is
there a way that the total can be hiden from the empty rows untill i enter
something on that row.
Cheers
Simon
Here is one that i use. It may not be the best but it works.

ASSUME that your "DATE" is in cell A1, your first row of data is Row 2
In the "Total" Column E, row 3 insert this formula and copy down
=IF(COUNT(C3:D3)=0,"",SUM(E2+C3-D3))

Dave