Set initial value to a cell and then update it using a formula

Deleted
Not applicable

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)

OR

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. 


Regards,

Tayyab

3 Replies

@Deleted 

Afraid that doesn't work in Excel Online since you have circular reference

@Sergei Baklan 

Is there a way to develop a For Loop in excel using default available formulas (without VBA code) ?

@Deleted 

To my knowledge - no