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 :

Date	Shift	Part	Qty
17-07-2018	A	Molding L	500
18-07-2018	A	Molding L	600
17-07-2018	B	Rr Lic Grn Camera	700
17-07-2018	A	Molding L	500
17-07-2018	B	Molding L	700

<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>
</tbody>

And the result i need is

Molding L	1800
Rr Lic Grn Camera	700

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