Forum Discussion
Solved
Daily Calculating
Hello All! I know how to show the formula =SUM(A1+B1) in cell C32. On the next day, I would like to show the result of =SUM(A2+B2) in C32 and so on until the last day, A31+B31. I just want the total...
Twifoothank you so much for your reply. I have had to figure out how to post this image. As you can see, I'm just getting the formula display in cell F14 and not the result of D11 + G11. I tried putting a (+) plus sign between D11 and G11, to get the 154.94. I'm not sure what to do. I hope this image helps you to understand what I am trying to accomplish. Thank you for your help.
Instead of an image, please attach your sample Excel file.
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.
