Remove Duplicates

morning. thank you to pike for deleting the dups. however, i'm now trying to include the 'de-duped' values in a 'sumif' function and excel is not recognizing the column values properly.

For example. in the tab 'raw data' 'ASSY-719222' appears 2 times, with a total of 4 units.
However, in the tab 'deduped data' 'ASSY-719222' correctly appears once, but the 'sumif' formula in column B only shows 1.

Any suggestions would be most helpful. thanks.