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