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

Question

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".&nbsp;#DateValuePayment&nbsp;Payment Cycle in Months3131/01/202210&nbsp;&nbsp;&nbsp;&nbsp;228/02/202220&nbsp;&nbsp;&nbsp;&nbsp;331/03/202230&nbsp;&nbsp;&nbsp;&nbsp;430/04/202240&nbsp;&nbsp;&nbsp;&nbsp;531/05/202250&nbsp;&nbsp;&nbsp;&nbsp;630/06/202260&nbsp;&nbsp;&nbsp;&nbsp;731/07/202270&nbsp;&nbsp;&nbsp;&nbsp;831/08/202280&nbsp;&nbsp;&nbsp;&nbsp;930/09/202290&nbsp;&nbsp;&nbsp;&nbsp;1031/10/2022100&nbsp;&nbsp;&nbsp;&nbsp;1130/11/202220&nbsp;&nbsp;&nbsp;&nbsp;1231/12/202230&nbsp;&nbsp;&nbsp;&nbsp;1331/01/202340&nbsp;&nbsp;&nbsp;&nbsp;1428/02/202350&nbsp;&nbsp;&nbsp;&nbsp;1531/03/202360&nbsp;&nbsp;&nbsp;&nbsp;1630/04/202370&nbsp;&nbsp;&nbsp;&nbsp;1731/05/202380&nbsp;&nbsp;&nbsp;&nbsp;1830/06/202390&nbsp;&nbsp;&nbsp;&nbsp;1931/07/2023100&nbsp;&nbsp;&nbsp;&nbsp;

bosinander · Answer

KHTT74&nbsp;Assuming #6, column payment equals cell D7;=SUM(OFFSET(C7,-G1,,G1))

Forum Discussion

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

1 Reply

#	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