Forum Discussion
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 of a single day to display in C32. Is this possible? I do not want a running total. I am calculating barrels of water from two different tanks (A and B). I want the number of barrels to display in cell C32. I just want that days' total production. It will be different each day. Right now I go to the formula in C32 each day and change the row number for A and B. I actually have more tanks than just two, but I'm simplifying here. I hope someone can figure out the formula for this. Thank you in advance.
Assuming the current date is always at the bottom of the list, the formula in F2 returns your expected result, as shown in the snapshot below:
24 Replies
- TwifooSilver Contributor
Assuming the current date is always at the bottom of the list, the formula in F2 returns your expected result, as shown in the snapshot below:
- VnorrellCopper Contributor
Hi again. I am attaching another spreadsheet that will show you exactly what I am doing. If you can figure out any way this can be done, I would appreciate it.
- VnorrellCopper Contributor
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.
- TwifooSilver ContributorInstead of an image, please attach your sample Excel file.
- mathetesSilver Contributor
This formula will produce the result you want:
=OFFSET(A1,DAY(TODAY())-1,,)+OFFSET(A1,DAY(TODAY())-1,1)
This is assuming that the data for the first of the month is entered in Row 1 of columns A and B, and each subsequent day's values are entered in the rows below.
the OFFSET function automatically will pick up the value in the row corresponding to the value of the day returned by TODAY(). The minus 1 is in there because, since it's starting its search in cell A1, we have to "go back 1" ....
But I think you get the idea... If you have questions, come back and ask them. A spreadsheet is attached that incorporates what I've just said.