title: Repeat loop until empty cell
body: <p>I am looking for an Excel formula, that can add the results of rows untill it hits an empty cell. </p>
  
  <p>The first row contains a the formula (including value X).
  The following rows each contain 3 cells (A,B,C) with values in them.
  It is simple True/False ("=IF(AND(X>=A2;X&lt;=B2);C2;0)) that checks if 'X' > is higher than A, and lower than B, and if true, it returns the value of the C.
  The formula then looks at the next row and repeats the action, and adds all the returned values to one sum.</p>
  
  <pre><code>ROW1 - A1(formula)
  ROW2 - A2(5) - B2(10) - C2(100)
  ROW3 - A3(10) - B3(20) - C3(200)
  ROW4 - (empty)
  
  ROW2 - If we set X=8, then 8 is &gt; 5, and &lt; 10, and the value 100 is returned.
  ROW3 - The action is repeated - this time with the result 0.
  ROW4 - The row/cell is empty and the loop stops.
  ROW1 - Formula has stopped and shows result (100 + 0 =) 100.
  </code></pre>