Counting total weeks cover

[brainboxbiscuit]

Hi I'm trying to count the max number of forecast cells which sum up to less than the order amount of 300

eg, 90+90+60+50=290, which is the highest summed value but is less than my order total of 300 so this is 4 weeks. This is the answer I want in my wks cover cell. I want my wks cover cell to show 4.
90+90+60+50+30=320 is greater than 300 and therefore do not want my wks cover to show this as its higher than 300

Can anyone help with the formula pls? (I have approx 400 lines with multiple different inputs so need something which helps multiple times, not just for this one instance)

Thanks

 

[JamesCanale]

MrExcelPlayground12.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Order	7	8	9	10	11	12	13	14	15	16	Wks Cover
2	300	90	90	60	50	30	30	30	30	30	30	4
Sheet17

Cell Formulas
Range	Formula
L2	L2	=SUMPRODUCT(--(SUBTOTAL(9,OFFSET(B2:K2,,,,COLUMN(B2:K2)-COLUMN(INDEX(B2:K2,1,1))+1))<=A2))