You can put your unique list of codes in D1 and below, for example,
then in E1 you can use this formula:

=SUMIF(B:B,D1,A:A)

and then copy this down as required.

Hope this helps.

Pete

On Apr 8, 7:12*pm, Gallego wrote:
Here's my scenario. *I have several status codes besides the example below. *
I want to put a counter on a spreadsheet that adds the qty for each code. *so
for MT the sum of items in that code is 5. *what is the formula?
Qty * * Status
2 * * * MT
1 * * * MT
1 * * * MT
2 * * * MT