I need help in creating a Formula, here is the sample below

A1
5
32
50
32

75 44 = 119

Formula must add all of A1 cells only up to a certain # (ex is 75)
In other words I need to split the total amount with a certain cell to be 75 or less and if more to be on another cell (ex: #44)



Hope someone can help out!

Thanks,
MO