Sum the Values in a Column until a set Sum is reached (<=), and restart Sum automatically

I have hundreds of shelves of a set width value (144") and thousands of SKU's of varying widths that I need to place on each shelf. I can leave some empty space on a shelf, but nothing can "hang" off a shelf.

Note that there are Rows with a value of 0, since that item will be comingled in box with an adjacent item (see table)

I have tried Indirect, Address and Row and several other functions but the solution evades me.
In columnA I have item widths and in ColumnB I have the sum I am hoping to obtain that is less than 144". When <=144 occurs I want to execute a SUM, and restart the Sum Function.

Thank you in advance for reading this, and I will appreciate any help you can provide.


ColA ColB
17.75
17.75
17.75
23.375
0
17.75
17.75
17.75 129.875
17.75
17.75
23.375
0
0
14
14
14
14
17.75 132.625
17.75
17.75
23.375
0
17.75
17.75
17.75
23.375
0
0 135.5
14
14

I put this formula in C2, so that you can compare it directly with your manual results in column B:

=IF(SUM(A$2:A3)-SUM(C$1:C1)>=144,SUM(A$2:A2)-SUM(C$1:C1),"")

Copy the formula down.

Hope this helps.

Pete

Chemist B,

Thank you for you solution as well... I am going to deploy its well as a learning experience. Thank you!!
Bob