Subtotal
 

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

Subtotal
 

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

Subtotal
 

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

Subtotal
 

The OP emailed his sheet directly to me last night (without
asking !!), so I put the formula in there and sent it back to him.

Pete

On Apr 9, 3:48*pm, ryguy7272
wrote:
Take a look at this:http://peltiertech.com/Excel/Pivots/...07.html#Unique

Regards,
Ryan--

--
RyGuy