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 |