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

Question

Activity #&nbsp; &nbsp; &nbsp;Total Time (yesterday)&nbsp; &nbsp; &nbsp; &nbsp; Time spent (today)&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;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.eTotal time (today) = Total Time (yesterday) + time spent (today)ORx (current value) = x(initial value) + constantIn 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.&nbsp;Regards,Tayyab

sergeibaklan · Answer

Deleted&nbsp;
Afraid that doesn't work in Excel Online since you have circular reference

deleted · Answer

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

sergeibaklan · Answer

Deleted&nbsp;
To my knowledge - no

Forum Discussion

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

3 Replies

Resources