Forum Discussion

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
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:
LastRowSum.xlsx10 KB

Silver Contributor

Jan 09, 2020

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:

LastRowSum.xlsx10 KB

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.
Brown #2 2020.xls72 KB
- Twifoo
  Silver Contributor
  Jan 10, 2020
  Vnorrell
  Please manually your expected values in the proper cells and explain the logic of each.
Vnorrell
Copper Contributor
Jan 09, 2020
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
  Silver Contributor
  Jan 10, 2020
  Instead of an image, please attach your sample Excel file.
  - Vnorrell
    Copper Contributor
    Jan 10, 2020
    Twifoo
    
    I would like to mention that this all begins on the 2nd day and ends on the first of the next month. I'm not sure if that matters. But it might.

Resources