The macro totals the amounts for the unique ID's on the sample sheet and puts them into a sorted list.
My line of thought being simple formulas on your ITEMTOTALS sheet to look at the 2 column list rather than looking at what you are attempting to use.

I admit not understanding what your trying to achieve.

Good luck with your project.