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: 

Vnorrell's avatar
Vnorrell
Copper Contributor
Jan 10, 2020

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
Jan 10, 2020

Vnorrell 

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

Resources