title: Google Sheets - Match 3 conditions with Minus, CONCATENATE and SUM
body: <p>I want to use <code>SUM</code> to calculate from seconds row until before the current row.</p>
  
  <p><a href="https://i.stack.imgur.com/v7qCm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v7qCm.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/npla3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/npla3.png" alt="But I get an error with must be a range"></a></p>
  
  <p>But I get an error with <strong>must be a range</strong></p>
  
  <p>I want an expected result is <strong>C17</strong></p>
  
  <p>Code:</p>
  
  <pre><code>SUM(C7:CONCATENATE("C", MINUS(row(),1)))
  </code></pre>
  
  <p>.</p>