dyamic array/range - rolling equation

[beng986]

I have a few inputs in A1:B3:

months 20
Price per month 30
cost 180

then in:
A5 =sequence(1,b1,1,1)
A6 =sequence(1,b1,B2,0)
A7 =If(A5#=1,b3,0)

This gives me a useful and dynamic table. However, I would add a rolling P&L from A8 for the length of the number of months? Below is the result that I am trying to achieve (the bold line is A8). Any help would be very helpful

Price per month	30	30	30	30	30	30	30	30	30
Cost	180	0	0	0	0	0	0	0	0
P&L (The line I am struggling with)	-150	-120	-90	-60	-30	0	30	60	90

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		20
2		30
3		180
4
5		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
6		30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30
7		180	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
8		-150	-120	-90	-60	-30	0	30	60	90	120	150	180	210	240	270	300	330	360	390	420
Data

Cell Formulas
Range	Formula
B5:U5	B5	=SEQUENCE(,B1)
B6:U6	B6	=SEQUENCE(,B1,B2,0)
B7:U7	B7	=IF(B5#=1,B3,0)
B8:U8	B8	=SUMIFS(B6#,B5#,"<="&SEQUENCE(,B1))-B7
Dynamic array formulas.

 

[beng986]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		20
2		30
3		180
4
5		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
6		30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30
7		180	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
8		-150	-120	-90	-60	-30	0	30	60	90	120	150	180	210	240	270	300	330	360	390	420
Data

Cell Formulas
Range	Formula
B5:U5	B5	=SEQUENCE(,B1)
B6:U6	B6	=SEQUENCE(,B1,B2,0)
B7:U7	B7	=IF(B5#=1,B3,0)
B8:U8	B8	=SUMIFS(B6#,B5#,"<="&SEQUENCE(,B1))-B7
Dynamic array formulas.

amazing thank you

 

[Fluff]

You're welcome & thanks for the feedback.