Take a look at this:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot07.html#Unique


Regards,
Ryan--

--
RyGuy


"Pete_UK" wrote:

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