BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 267
- Office Version
- 2016
- Platform
- Windows
hello experts I am trying to write a formula that adds up the monthly ongoing costs, right now I have it linked to individual cells but trying to make it so the values in yellow update when the start date changes, please help
| running total.xlsx | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
| 2 | Start | Ongoing Monthly cost | 01-Aug-21 | 01-Sep-21 | 01-Oct-21 | 01-Nov-21 | 01-Dec-21 | 01-Jan-22 | 01-Feb-22 | 01-Mar-22 | 01-Apr-22 | 01-May-22 | 01-Jun-22 | 01-Jul-22 | ||||
| 3 | 01-Aug-21 | 150,000 | Total monthly cost | 567,500 | 657,500 | 657,500 | 657,500 | 869,000 | 934,000 | 1,099,000 | 1,099,000 | 1,099,000 | 1,099,000 | 1,099,000 | 1,099,000 | |||
| 4 | 01-Aug-21 | 120,000 | ||||||||||||||||
| 5 | 01-Aug-21 | 72,500 | ||||||||||||||||
| 6 | 01-Aug-21 | 55,000 | ||||||||||||||||
| 7 | 01-Aug-21 | 67,500 | ||||||||||||||||
| 8 | 01-Aug-21 | 32,500 | ||||||||||||||||
| 9 | 01-Aug-21 | 35,000 | ||||||||||||||||
| 10 | 01-Aug-21 | 15,000 | ||||||||||||||||
| 11 | 01-Aug-21 | 10,000 | ||||||||||||||||
| 12 | 01-Aug-21 | 10,000 | ||||||||||||||||
| 13 | 01-Sep-21 | 90,000 | ||||||||||||||||
| 14 | 01-Dec-21 | 70,000 | ||||||||||||||||
| 15 | 01-Dec-21 | 85,000 | ||||||||||||||||
| 16 | 01-Dec-21 | 56,500 | ||||||||||||||||
| 17 | 01-Jan-22 | 65,000 | ||||||||||||||||
| 18 | 01-Feb-22 | 165,000 | ||||||||||||||||
Sheet1 | ||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G3 | G3 | =SUM($D$3:$D$12) |
| H3:J3 | H3 | =SUM($D$3:$D$12)+$D$13 |
| K3 | K3 | =SUM($D$3:$D$12)+$D$13+SUM($D$14:$D$16) |
| L3 | L3 | =SUM($D$3:$D$12)+$D$13+SUM($D$14:$D$16)+$D$17 |
| M3:R3 | M3 | =SUM($D$3:$D$12)+$D$13+SUM($D$14:$D$16)+$D$17+$D$18 |
