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.



[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 64"]sheet 1[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl68"]CO #[/TD]
[TD="class: xl68"]QTY[/TD]
[/TR]
[TR]
[TD="class: xl63"]12345[/TD]
[TD="class: xl65, align: right"]120[/TD]
[/TR]
[TR]
[TD="class: xl63"]17711[/TD]
[TD="class: xl66"] 45 [/TD]
[/TR]
[TR]
[TD="class: xl63"]19571[/TD]
[TD="class: xl66"] 55 [/TD]
[/TR]
[TR]
[TD="class: xl63"]24199[/TD]
[TD="class: xl66"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49017[/TD]
[TD="class: xl66"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl64"]49019[/TD]
[TD="class: xl67"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl64"]49019[/TD]
[TD="class: xl67"] 80 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49026[/TD]
[TD="class: xl66"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49035[/TD]
[TD="class: xl66"] 40 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49036[/TD]
[TD="class: xl66"] 70 [/TD]
[/TR]
[TR]
[TD="class: xl64"]49321[/TD]
[TD="class: xl67"] 60 [/TD]
[/TR]
[TR]
[TD="class: xl64"]49321[/TD]
[TD="class: xl67"] 45 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49324[/TD]
[TD="class: xl66"] 100 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49461[/TD]
[TD="class: xl66"] 25 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49476[/TD]
[TD="class: xl66"] 35 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49496[/TD]
[TD="class: xl66"] 60 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49785[/TD]
[TD="class: xl66"] 60 [/TD]
[/TR]
[TR]
[TD="class: xl63"]49789[/TD]
[TD="class: xl66"] 70 [/TD]
[/TR]
[TR]
[TD="class: xl63"] 49848[/TD]
[TD="class: xl66"] 35



[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]sheet 2[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl70"]CO #[/TD]
[TD="class: xl70"]QTY[/TD]
[/TR]
[TR]
[TD="class: xl65"]12345[/TD]
[TD="class: xl67, align: right"]120[/TD]
[/TR]
[TR]
[TD="class: xl65"]17711[/TD]
[TD="class: xl68"] 45 [/TD]
[/TR]
[TR]
[TD="class: xl65"]19571[/TD]
[TD="class: xl68"] 55 [/TD]
[/TR]
[TR]
[TD="class: xl65"]24199[/TD]
[TD="class: xl68"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49017[/TD]
[TD="class: xl68"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl66"]49019[/TD]
[TD="class: xl69"] 130 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49026[/TD]
[TD="class: xl68"] 50 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49035[/TD]
[TD="class: xl68"] 40 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49036[/TD]
[TD="class: xl68"] 70 [/TD]
[/TR]
[TR]
[TD="class: xl66"]49321[/TD]
[TD="class: xl69"] 115 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49324[/TD]
[TD="class: xl68"] 100 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49461[/TD]
[TD="class: xl68"] 25 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49476[/TD]
[TD="class: xl68"] 35 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49496[/TD]
[TD="class: xl68"] 60 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49785[/TD]
[TD="class: xl68"] 60 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49789[/TD]
[TD="class: xl68"] 70 [/TD]
[/TR]
[TR]
[TD="class: xl65"]49848[/TD]
[TD="class: xl68"] 35 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.