Sorting/Filtering table makes Column M's formula output Wonky

[MacHead]

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

[LeoTaxi]

Cnange

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Kind regards
Leo

[FDibbins]

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

Also, please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[MacHead]

I attempted to upload my file to the forum during my initial post. I clicked on the paperclip icon and a blank thin window appeared. No prompts for uploading. Tried using a different browser but still didn't work. I figured I was restricted to upload files because i am not a regular user.

But i did upload onto google drive, which allows users to view the file in google sheets WITHOUT downloading it. Not sure what else I can do.

[MacHead]

Thank you! That solved it! I was making things more difficult than they needed to be