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

Hi and welcome

Say your limit is 75

In your result cell (say A11)In the next cell ( say B11)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post