title: Google Sheet SUMIF not summing range
body: <p>I am trying to SUM all rows based on the condition that a row's value is greater than 0. However, the formula is only calculating the first row and ignoring the rest of the range. I encountered this issue on a different spreadsheet but I isolated the issue on a new spreadsheet to show you and ask questions.</p>
  
  <p>The answers should be B1 ($5), B2 ($15), B3 ($30). 
  I followed the formula's usage as explained in the Google Docs <a href="https://support.google.com/docs/answer/3093583?hl=en" rel="nofollow noreferrer">https://support.google.com/docs/answer/3093583?hl=en</a></p>
  
  <p>The formula with respective row number <code>=SUMIF(A1, "&gt;0", A$1:A1)</code></p>
  
  <p><a href="https://i.stack.imgur.com/3afHU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3afHU.png" alt="enter image description here"></a>
  <hr/>
  Update - The below is my intended purpose. I have a spreadsheet that calculates money In and Out. For each of these transactions, I simply want the balance as a result of such transactions. This only works for the first row. (I hardcoded the values for the rest of the rows just to show my goal.)</p>
  
  <p><a href="https://i.stack.imgur.com/2lkOk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2lkOk.png" alt="enter image description here"></a></p>