Need to sum values till sum is 1

[fabian_andrew]

Hi , I have a set of numbers and I want to get the sum till it is 1 and then again sum .

A- 0.2 ,0.3 ,0.5 .0.1 -- 0.2 ,0.3 , 0.5 ,1

Sum when it is less than .5 till it is 1

Please help

 

[mikerickson]

If you have the numbers in column A, then put =A1 in cell B1 and

=((B1<1)*B1)+A2 in B2, then drag that formula down.

You may prefer <=

 

[fabian_andrew]

I need to sum till it is 0.5 and then start again,

like if I have .3 .3 .3 at I should get .6 and .3

 

[mikerickson]

Then change the 1 in the above formula to .5