title: EXCEL : SUM many rows with condition
body: <p>I have 3 columns,
  column A contain value that need to calculate later, and column B contain status ( 0 / score ), column C is going to create SUM function with range, but with condition from first score status to the second one.
  for example : from this</p>
  
  <pre><code>1| point | status | SUM
  2|------------------------
  3|   3   | score  | &lt;script here&gt;
  4|   2   | 0      | &lt;script here&gt;
  5|   5   | 0      | &lt;script here&gt;
  6|   9   | 0      | &lt;script here&gt;
  7|   1   | score  | &lt;script here&gt;
  8|   2   | 0      | &lt;script here&gt;
  9|   3   | score  | &lt;script here&gt;
  </code></pre>
  
  <p>to this : </p>
  
  <pre><code>1| point | status | SUM
  2|------------------------
  3|   3   | score  | SUM(A3:A7)
  4|   2   | 0      | 0
  5|   5   | 0      | 0
  6|   9   | 0      | 0
  7|   1   | score  | SUM(A7:A9)
  8|   2   | 0      | 0
  9|   3   | score  | SUM(A9:xx)
  </code></pre>
  
  <p>for now, this is how i get it the first one, but don't know how to get the second one.</p>
  
  <pre><code>=IF(B3="score";
    SUM(
         ADDRESS(ROW(B3);1;4) :
         &lt;dont know how to detecting rows below that have score value&gt;;"0")
  </code></pre>
  
  <p>.</p>
  
  <pre><code>=IF(B3="score";SUM(ADDRESS(ROW(B3);1;4):&lt;how&gt;;"0")
  </code></pre>