Hide Info

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

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

There are two ways to handle this. You can turn off the display of zeros
under Tools, Options, View. Or you can use a formula similar to this:
=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

--
Jim
"Simon" <Simon@discussions.microsoft.com> wrote in message
news:A7629351-B666-4496-A5BD-8B13EE3D0052@microsoft.com...
|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