title: Invoice List Running Balance based on date and Account
body: <p>I'm using Excel 2010 and have made a UserForm that Displays a complete list of Invoices from Worksheets("InvoiceListIncome") using a ListBox control, the Worksheet has 13 Columns and Thousands of rows, an example image below;
  <img src="https://i.stack.imgur.com/GVxQ7.jpg" alt="">
  The problem I'm having is the Balance Row Range("InvoiceListIncome_Balance")" displays the balance of each Invoice individual, what I need is a running balance starting from the first invoice Range("InvoiceListIncome_Date") so with each Transaction it Adds up the Current + all previous invoices for that account.</p>
  
  <p>The Macro I'm currently using is;</p>
  
  <pre><code>Range("InvoiceListIncome_Balance").FormulaR1C1 = "=SUM(RC[-1])-SUM(RC[-2])"
  </code></pre>
  
  <p>which simply subtracts whats Paid in Column F from Item Price in Column G, but I cant seem to figure out how to add all previous balances by date, I can either get it to Sum the complete Range with the Customers account as the criteria or just the activerow.</p>
  
  <p>I have been running circles trying to figure this out for days now, any help would be muchly appreciated, thanks.</p>
  
  <p>Here is an example of what I need;
  <img src="https://i.stack.imgur.com/EnlNf.jpg" alt="enter image description here"></p>