duplicate product with different qty in 2nd cell

[azii]

Dear all
I have a sheet (sheet 1) where I have duplicate CO# and there QTYs but in sheet 2 I have CO # but I want the sum of QTY against a CO# which is repeated in sheet 1.
I am stuck there, couldn't develop any formula. Please help me to resolve this issue.
I will be gratefull to you all.

sheet 1
CO #	QTY
12345	120
17711	45
19571	55
24199	50
49017	50
49019	50
49019	80
49026	50
49035	40
49036	70
49321	60
49321	45
49324	100
49461	25
49476	35
49496	60
49785	60
49789	70
49848	35 sheet 2 CO # QTY 12345 120 17711 45 19571 55 24199 50 49017 50 49019 130 49026 50 49035 40 49036 70 49321 115 49324 100 49461 25 49476 35 49496 60 49785 60 49789 70 49848 35 <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> </tbody>

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Why 49321 is 115 on Sheet2?

 

[gaj104]

Assuming a miscalc of 49321 which should be 105 instead, then use =SUMIF(Sheet1!A:A,A2,Sheet1!B:B) in sheet2 cell B2 and then copy down.

 

[azii]

this was great,
your command resolved the problem
God Bless you.