How to hide values in a running balance untill new data is entere.

[doggydog]

I'm trying to make a spreadsheet to keep track of the miles I bike and the
total time. For each of these, I made a running balance. The entire range
displays the total. I would like to hide the displayed future totals untill
a new value is entered for that particular day.

example: miles total
1 1
2 3
3
3
3

I don't want to see all those 3's until I input new data

example: miles total
1 1
2 3
3 6

Thanks for any help

[Biff]

Hi!

Assume your miles column is column A and totals is column
B.

A1 = Miles
B1 = Total

A2 = 1

Formula in B2:

=IF(A2="","",SUM(B1,A2))

Copy down as needed.

Biff

>-----Original Message-----
>I'm trying to make a spreadsheet to keep track of the
miles I bike and the
>total time. For each of these, I made a running
balance. The entire range
>displays the total. I would like to hide the displayed
future totals untill
>a new value is entered for that particular day.
>
>example: miles total
> 1 1
> 2 3
> 3
> 3
> 3
>
>I don't want to see all those 3's until I input new data
>
>example: miles total
> 1 1
> 2 3
> 3 6
>
>Thanks for any help
>.
>