Forum Discussion
Daily Calculating
Here's a spreadsheet derived from yours that gives you three different ways to get the number of barrels for a day of the month.
- First, there's a simple column down the right of your list of each day's numbers that totals columns D and G. That's the simplest, and as it happens, the most interesting and potentially valuable because it gives you the history as well.
- Second, IF you are really just going to keep the records for the current month, then there is a spot where you can enter the number for any given single day and have Excel automatically retrieve the total for that day
- Third, IF you are really just keeping the current month's records, there's a spot that automatically summarizes Today's total once you've entered the particulars. This last is the most ephemeral, of course, since nothing appears until you enter the details, and then it's gone the next morning.
So my favorites are #1 or #2, depending on how long you keep the daily records.
Thank you for your help. However, none of the options will work . I am attaching a file so you can see the reason for my request. Maybe this will help you understand.
You say "none of the options will work"
But there's nothing in that spreadsheet that precludes the simplest and most effective solution. See the attached revised version of your sheet.
Tell me please why that doesn't work. It gives you the functional answer you've been asking for; maybe not in the FORM you've been asking for it....and if that's the issue, then please explain why that FORM is the only way it can work. OR, as Twifoo has requested give us a manually created version of the answer you're looking for in the cell you're wanting it. We're just showing you that the calculations can be done quite simply in several different ways. We're not saying you have to have it in the form or format we're showing....
@twifoo & mathetes
Again, thank you for your help. I will try to explain. In the Brown #2 2020 spreadsheet, cell X39 is the result of (O11+R11). The amount in cell X39 which I have named "Ending Stock" is added to the cell X40 , which I have named "Pipeline Runs". The "Total" of X39 + X40 is in cell X42. Then the amount in X42 subtracts X43 to give the daily "Production" in X44. If you notice the formula in X43, it is (O5+R5), which is the beginning stock on January 1st of 195.30. This is the way this company wants their spreadsheet to look. I was just trying to make X39 automatically add O and R. I go in each day to X39 and change the formula to O12+R12, then to O13+R13 and so on until the last day of the month. The most important figure the company looks at is the end figure called "Production" in cell X44. I don't know how to explain this any better. It seems simple, but it is not, and that is why I am here. If it can't be done, then fine. I'll just change the formula daily like I have been doing.