Simple Loop & Sum Question

[lhernandez]

OK, this should be an easy question, but for some reason my logic is not working.
I have a spreadsheet with approx. 900 lines. Column D has a "code" to break up the column into different groups, but the codes are scattered throughout. Column K has a quantity in it.
How can I write a loop to sum up all the values that are within a "code"?
Ex:
AAA - 2
AAA - 2
ABA - 2
ACB - 4
BBB - 7
ABA - 6
ACB - 3
BBB - 1
BBB - 1

So for all AAA sum the values and so on.
Is this possible if I do not know the code?

 

[Norie]

Couldn't you just use a pivot table or a SUMIF formula?