View Single Post
  #1   Report Post  
doggydog
 
Posts: n/a
Default How to hide values in a running balance untill new data is entere.

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