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...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Jan 09, 2020

    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: 

mathetes's avatar
mathetes
Silver Contributor
Jan 09, 2020

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