pdeemartin58
New Member
- Joined
- Feb 4, 2025
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Assist in formulas C3 and D3 greatly appreciated.
C3 solution should give the value of A3 - the totals filled into the series e3
3 + the total for the remaining blank cells if they each contained the current average of the series.
D3 similar idea but the blank cells in the series would each be filled in with the last amount entered (May in Exhibit A below).
Each upcoming month a new entry is inserted, and the formulas should reflect the new data without requiring a rewrite of the formula (I hope!).
Thank you in advance.
PS: Sorry, in hindsight I should have left Column B off my exhibit as it has no bearing on the questions.
C3 solution should give the value of A3 - the totals filled into the series e3
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
D3 similar idea but the blank cells in the series would each be filled in with the last amount entered (May in Exhibit A below).
Each upcoming month a new entry is inserted, and the formulas should reflect the new data without requiring a rewrite of the formula (I hope!).
Thank you in advance.
PS: Sorry, in hindsight I should have left Column B off my exhibit as it has no bearing on the questions.