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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top