Continuing sum formula

[bamacwby]

If I have a number, say 1245 in A1, that is the number I want to start with and in B2 is the same number but I add a series of other numbers to B2 with the total in F4. With everyday I erase the series of numbers that were added to B2 but want to keep the total form F4 to be the new number in B2. I hope this makes sense. Thank you

 

[Joe4]

Can you please show us an example of what your data looks like and expected result?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[bamacwby]

What I'm trying to do is the data in cell G2 is my starting number , the data in Cell M22 and three other "FLT DAY TOTALs" along with a weekly total down at the bottom of the worksheet are all added together and put in Cell I6. When I remove the data from M22 and the other three "FLT DAY TOTALs", the data in I6 reverts to my starting number form G2 like it should. But what I am trying to do is after my weekly total is in Cell I6 I want it to stay the same that way when I input the data into the "FLT DAY TOTALs" it will continue to add up form the previous Cell I6 data. I hope this make sense. Thank you

 

[Joe4]

I am not sure how to do that without VBA, or re-structuring your workbook to keep/store all the initial values.
It may be possible to use "Circular references" to try to sum like that, but that is not my forte.
You may want to try Googling something like "excel continuous sum using circular reference" and see what comes up.

 

[bamacwby]

What is a VBA? Or how I go about re-structuring my workbook?

 

[Joe4]

VBA = Visual Basic for Applications (VBA code)

Regarding restructuring, you would just re-design so that you never erase/delete any data that you want included in any sums.
So you would just track/keep all historical data. You could hide old data, if you don't want to see it after a certain period of time.