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.

 

[bamacwby]

How well do you know VBA's?

 

[Joe4]

I, and a lot of other people on this forum, know VBA very well.

I think what you may want is something to "reset" your numbers for the next batch of entry, something that changes certain calculated value to hard-coded value, and clear out other values.
But I am not 100% clear on your description. It would be helpful if you could walk us through an actual example, showing us some starting values and expected results, in a view that includes column and row references so we can see exactly what (and where) you are talking about.

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]

I, and a lot of other people on this forum, know VBA very well.

I think what you may want is something to "reset" your numbers for the next batch of entry, something that changes certain calculated value to hard-coded value, and clear out other values.
But I am not 100% clear on your description. It would be helpful if you could walk us through an actual example, showing us some starting values and expected results, in a view that includes column and row references so we can see exactly what (and where) you are talking about.

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.

If you reference the pic in my last post, you'll see that 6209.8 is in cell G2 (which is my starting value). And is is in cell I6 (which has a formula of =SUM(C77,G2). In cell C77 is the formula =SUM(M22,M39,M58,M74). which is each days total of flight time for that specific day. when I input a 1.5 into cell M18, cell M22 equals 1.5 and the 6209.8 that is in cell I6 increases by 1.5 to 6211.3. now when I erase the 1.5 from cell M18, cell M22 reverts back to 0 (like I want it to) but the 6211.3 in cell I6 also decreases by 1.5.Which is what I don't want it to do, I want it to stay 6211.3. so that the next time I go fly and put my flight time into cell M18 it will add to the value in cell I6. I hope this make sense now. Thank you

 

[Joe4]

Obviously, you are referring to a bunch of cells that are not shown in your screen print, as it only shows up to row 23.
In order to help, I think I would need to get a copy of your workbook, so I can see all the rows, and all the formulas, and try it the steps you are mentioning.
Are you able to upload your workbook to a file sharing site and provide a link to it here?