Add number to cell 1, add it to cell 2,

Our take

Certainly, Andy! You can achieve this by using a simple formula in your spreadsheet. In cell I6, input the formula `=I6 + F6` to add the value from cell F6 to the cumulative total. Each week, when you input your new quantity in F6, the total in I6 will automatically update. Remember to first clear the previous quantity from F6 before entering the new value. This way, you can effectively track your weekly progress without losing the accumulated totals. Happy tracking!

I am making a weekly work progress sheet. I am an electrical contractor and want to be able to input my weekly quantities in say cell f6. I want to add that to cell i6. I want to be able to delete the number in cell f6 every week to input the new quantity for the week and I want cell i6 to keep adding the total.

Lets say we are installing conduit. week 1 we install 300'. I will put that into cell f6 and cell i6 will copy that number 300'. Next week we have 325' of the same conduit I want to delete the 300 from cell f6 and put in 325 but I want cell i6 to say 625. The following week we install 400' of the same conduit. I want to delete the 325 from cell f6 and put in 400' and have cell i6 show 1025'.

Is this possible and how would I do that?

Thanks

Andy

submitted by /u/HouseNo8033
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#weekly work progress sheet#installing conduit#electrical contractor#input quantities#total#weekly total#cell f6#cell i6#weekly quantities#input new quantity#keep adding#delete number#copy number#install 300'