Hi there,

I made an accounts receivable table that should allow me to track Clients and Invoices we have submitted. It all seems to be working well... I even created a formatting rule to highlight outstanding balances.

Problem is Column M. It is supposed to calculate the Remaining Balance. When I change views and sort by Client name, Invoice number, or any other column (with or without filtering results), I notice that column M is no longer accurate. The cells highlighted in the formula to calulate the Balance (column M) aren't even all on the same row. What am i doing wrong?

I want Column M to always equal Amount Due (Column D) minus Payment Received (Column J) for each row entry.

The first row with invoicing data begins on row 3. The formula in column M reads: =Sheet1!$D3-Sheet1!$J3

Screenshot of issue is below. Also, a de-identified spreadsheet is uploaded to google drive: https://drive.google.com/file/d/0B47...ew?usp=sharing

Thank you for your help.

Screen Shot 2017-01-16 at 4.31.28 PM.png