SUMIF problem with sorting

Hello,
I created an inventory spread sheet to help keep track of a parts inventory.
I used the VLOOKUP function on column C and D in the "SOLD AND RECEIVED" tab to look up the special part code for each part "#" column A on the tab "INVENTORY LIST".
In column F "QTY" of tab "SOLD AND RECEIVED" will be the quantity of that part sold or received in.
I used the SUMIF function in column F "MOVEMENT" in the "INVENTORY LIST" tab to calculate any parts movement listed in column F and then a simple function to add the the movement with the original count (Column E) to give me the live count (Column G).

If I use SORT A to Z on column H "LOCATION" The movement / live counts are not correct.
Can someone please help me to keep the counts accurate when I sort by location?

Please let me know if you need more information.
Thank you,
Nikki

Try removing the sheet name for the cell you're summing from your formula:

Please Login or Register  to view this content.