Microsoft Excel question

[Rux]

This is what I'm asking,
I have a series of numbers in column (A) and description in column (B) QTY
in column (C).

Column A Column B Column C
Item number Description QTY
12129001 Custom d 5
12129003 Customer f 8
12129271 Customer g 2
12129360 Customer h 6

12182001 Customer j 12
12182003 Customer k 7
12183271 Customer l 38

What would like to do is delete, or only show the first five digits in
column (A). Then I get a subtotal of 12129's and a subtotal of 12182's.
Currently, the subtotal is separating the Item number because of the last
three digits, the last three digits are related to the customer description.
The 12182's are all the same product, just coded different for the customer.
All I require to the total of 12182's on order.

Yes, I could separate by inserting a row and then do a sum by item number,
but I like to have a sum of the qty of the generic item number.

Sorry for the poor problem description,

Help,

 

[Bernard Liengme]

=SUMPRODUCT(--(LEFT(A3:A10,5)="12129"),C3:C10)
but you should ask questions like this in
best wishes

 

[Rux]

Thank you for your help Bernard.
I tried your suggestion and its not what I was hoping to do.

I'm not looking to sum column A, just list only the first five digits.
Example: 12129
12182

I am looking to remove the last three digits, 001, 003, 271, 360 etc.

Thanks again,

Rux

 

[Rux]

Oh, how do I get to "
Thanks,

Ted

=SUMPRODUCT(--(LEFT(A3:A10,5)="12129"),C3:C10)
but you should ask questions like this in
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

 

[Bob I]

Double Click this link and your NG reader should take you there.

news://msnews.microsoft.com/microsoft.public.excel

 

[Bernard Liengme]

You want to sum C for each different Item?
That is what I showed
I cannot think you want to sum item numbers!
best wishes