Forum Discussion

Vnorrell's avatar
Vnorrell
Copper Contributor
Jan 08, 2020
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 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.

24 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor

    Vnorrell 

    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: 

    • Vnorrell's avatar
      Vnorrell
      Copper Contributor

      Twifoo 

       

      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.

      • Twifoo's avatar
        Twifoo
        Silver Contributor

        Vnorrell 

        Please manually your expected values in the proper cells and explain the logic of each. 

    • Vnorrell's avatar
      Vnorrell
      Copper 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. 

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Instead of an image, please attach your sample Excel file.
  • mathetes's avatar
    mathetes
    Silver Contributor

    Vnorrell 

     

    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.

     

     

Resources