Activity # Total Time (yesterday) Time spent (today)
1 4 2
2 0 4
3 3 5
4 2 0
I have a data similar to the one shown above. I want to update my total time for every activity based on the time spent (today). Initially I want to set the value of all the cells in Total Time to zero and then update it based on my data from today . So I want to write a formula that adds the time spent from today to current value of Total time from yesterday for every activity. i.e
Total time (today) = Total Time (yesterday) + time spent (today)
x (current value) = x(initial value) + constant In other words I want to have a way to save the total time values from yesterday. With for Loop it is possible but I can not use VBA or Macros as I am working at excel online.