title: Sum above cells ignoring blanks
body: <p>I have a spreadsheet where I have data from a bank account. Each bank transaction has a date and an indication if that transaction is already done or if it's just expected. When it's already done, it must be added to the total balance up to date. If not, then the total balance up to date must be blank. I need to autofilter the data, so I can filter and order it depending on date or other conditions, that's why I've been using this formula:</p>
  
  <pre><code>=IF(D3="Y";B3+INDIRECT(ADDRESS(ROW()-1;COLUMN()));"")
  </code></pre>
  
  <p>Problem here is that when the cell above is blank, total sum resets and it starts from the value of that transaction. I need a formula that ignores the upper blank cells, and sums all cells above that are not blank plus the amount of that transaction.</p>
  
  <p>Besides, once I change the "N" in "Done" Column to a "Y" I need the formula to update and show the correct balance.</p>
  
  <p>I share an example sheet for better understanding <a href="https://docs.google.com/spreadsheets/d/1_gk0YaziUhOZfRbrlfHizMrVu6OT7njIaTUyQaE6Lbs/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1_gk0YaziUhOZfRbrlfHizMrVu6OT7njIaTUyQaE6Lbs/edit?usp=sharing</a></p>