Running Total Reset after Threshold

[blind12]

I need a formula that resets after a certain threshold is met on a running total. So example: when the number in A3 is reached in the running total of C1:M1, then $A3$ is placed in C3:M3. in the screen shot I show this example by listing A3 in the cells that this would take place in.

 

[Cubist]

-

 

[Cubist]

How about this?

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			300	315	331	347	365	383	402	422	443	465	489
2	Unit Min Order Qty
3	1000					1000			1000			1000
Sheet1

Cell Formulas
Range	Formula
C3:M3	C3	=IF((SCAN(0,C1:M1,LAMBDA(a,b,LET(c,a+b,IF(c<=A3,c,0))))=0)*(C1:M1<>0),A3,"")
Dynamic array formulas.

 

[blind12]

How about this?

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			300	315	331	347	365	383	402	422	443	465	489
2	Unit Min Order Qty
3	1000					1000			1000			1000
Sheet1

Cell Formulas
Range	Formula
C3:M3	C3	=IF((SCAN(0,C1:M1,LAMBDA(a,b,LET(c,a+b,IF(c<=A3,c,0))))=0)*(C1:M1<>0),A3,"")
Dynamic array formulas.

thank you so much!!! I really appreciate it!

 

[Cubist]

Change the inequality "<=" to "<". This will account for when the sum is exactly 1000.