I have excel sheet and I want do a sum formula with dynamic starting cell.

[KHTT74]

I have excel sheet and I want do a sum formula with dynamic starting cell.

for example, in payment column row number 6 I want the ending cell in sum formula is row number 6 in value column and the starting cell will be dynamic by going up number of cells mentioned beside "Payment Cycle in Months".

#	Date	Value	Payment		Payment Cycle in Months	3
1	31/01/2022	10
2	28/02/2022	20
3	31/03/2022	30
4	30/04/2022	40
5	31/05/2022	50
6	30/06/2022	60
7	31/07/2022	70
8	31/08/2022	80
9	30/09/2022	90
10	31/10/2022	100
11	30/11/2022	20
12	31/12/2022	30
13	31/01/2023	40
14	28/02/2023	50
15	31/03/2023	60
16	30/04/2023	70
17	31/05/2023	80
18	30/06/2023	90
19	31/07/2023	100

[#2]

@KHTT74 

Assuming #6, column payment equals cell D7;

=SUM(OFFSET(C7,-G1,,G1))