Sumifs formula with ingnoring the duplicates dates or shifts or so on

[Naveenaggarwal]

Hi!,

Please help me out to conclude the formula. I need total production quantity but without duplicates entry which may there in the...

My Data is like below :

<colgroup><col style="mso-width-source:userset;mso-width-alt:2583;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:2117;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:4026;width:87pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:1605;width:35pt" width="46"> </colgroup><tbody>
[TD="class: xl63, width: 74"] Date
[/TD]
[TD="class: xl63, width: 61"]Shift[/TD]
[TD="class: xl63, width: 115"]Part[/TD]
[TD="class: xl63, width: 46"]Qty[/TD]

[TD="class: xl65"]17-07-2018
[/TD]
[TD="class: xl65"] A
[/TD]
[TD="class: xl66"]Molding L[/TD]
[TD="class: xl63"]500[/TD]

[TD="class: xl65"]18-07-2018[/TD]
[TD="class: xl65"] A
[/TD]
[TD="class: xl66"]Molding L[/TD]
[TD="class: xl63"]600[/TD]

[TD="class: xl65"]17-07-2018[/TD]
[TD="class: xl65"] B
[/TD]
[TD="class: xl66"]Rr Lic Grn Camera[/TD]
[TD="class: xl63"]700[/TD]

[TD="class: xl65"]17-07-2018[/TD]
[TD="class: xl65"] A
[/TD]
[TD="class: xl66"]Molding L[/TD]
[TD="class: xl63"]500[/TD]

[TD="class: xl65"]17-07-2018
[/TD]
[TD="class: xl65"]B[/TD]
[TD="class: xl66"]Molding L[/TD]
[TD="class: xl63"]700[/TD]

</tbody>

And the result i need is

<colgroup><col style="mso-width-source:userset;mso-width-alt:4026;width:87pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:2583;width:56pt" width="74"> </colgroup><tbody>
[TD="class: xl65, width: 115"]Molding L[/TD]
[TD="class: xl67, width: 74"] 1800
[/TD]

[TD="class: xl65"]Rr Lic Grn Camera
[/TD]
[TD="class: xl65"] 700
[/TD]

</tbody>

Thanks

 

[Aladin Akyurek]

In H2 control+shift+enter, not just enter, and copy down:

=SUM(IF(FREQUENCY(IF($C$2:$C$6=G2,MATCH($A$2:$A$6&"|"&$B$2:$B$6&"|"&$C$2:$C$6,$A$2:$A$6&"|"&$B$2:$B$6&"|"&$C$2:$C$6,0)),ROW($A$2:$D$6)-ROW(INDEX($A$2:$D$6,1,1))+1),$D$2:$D$6))

where G2 = Molding L and G3 = Rr Lic Grn Camera.