Sum cell values incrementally and print value when reaching specific sum or more?

Question

Is there a way to run through a column of number values in google spreadsheets (like in a "while" loop), incrementally suming the values and when reaching specific value print it in the corresponding cell? Example:

So here I sum up all the elements in A column, when reaching >=40 I print the value, refresh the counter, and continue this iteration, counting till the end of the column. So I get these portions of elements with approx. equals sum values.

Thank you!

Answer 1

Looks like a job for a custom function. In cell B2, put =sumuntil(A2:A, 40) where the code of sumuntil, entered in Script Editor, is

function sumuntil(arr, limit) {
  var out = [];
  var sum = 0;
  for (var i in arr) {
    sum = sum + arr[i][0];
    if (sum >= limit) {
      out.push([sum]);
      sum = 0;
    }
    else {
      out.push([""]);
    }
  }
  return out;
}