Excluding Duplicate data in a SUMIF

[brandybartz]

My data source has duplicates in it that I need to only sum once and exclude the others. Below is my SUMIF that just sums everything but I need to add a portion that tells it to exclude the duplicates for each section of the formula.

=IFERROR(SUMIF('Item ST Weekly'!$C$1:$C$20164,CONCATENATE($D$8,"-",$B9,"-","Winner","-","Winner"),'Item ST Weekly'!$M$1:$M$20164)/(SUMIF('Item ST Weekly'!$C$1:$C$20164,CONCATENATE($D$8,"-",$B9,"-","Winner","-","Winner"),'Item ST Weekly'!$M$1:$M$20164)+SUMIF('Item ST Weekly'!$C$1:$C$20164,CONCATENATE($D$8,"-",$B9,"-","Winner","-","Winner"),'Item ST Weekly'!$N$1:$N$20164))," ") <colgroup><col width="1790" style="width: 1343pt; mso-width-source: userset; mso-width-alt: 65462;"> <tbody> </tbody>

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

 

[DanteAmor]

If you only need a single record of duplicates, then we can look for the first record.

=IFERROR(VLOOKUP($D$8&"-"&$B9&"-"&"Winner-Winner",'Item ST Weekly'!C1:M20164,11,0)/ (VLOOKUP($D$8&"-"&$B9&"-"&"Winner-Winner",'Item ST Weekly'!C1:M20164,11,0)+VLOOKUP($D$8&"-"&$B9&"-"&"Winner-Winner",'Item ST Weekly'!C1:N20164,12,0))," ")

 

[brandybartz]

I have more than one value that needs to be summed. Is there some kind of qualifier column I could add that would tag the first value as 1 and all other duplicates as 0. Then I could add that as part of my concat for summing??

 

[DanteAmor]

. Is there some kind of qualifier column I could add that would tag the first value as 1 and all other duplicates as 0. Then I could add that as part of my concat for summing??

Hoja5

	A	B
1
2	data2	0
3	data3	0
4	data4	0
5	data5	1
6	data6	1
7	data2	0
8	data3	1
9	data4	1
10	data2	1

<tbody>
</tbody>

Formula

Cell Formula B2 =IF(COUNTIF(A2:$A$10,A2)>1,0,1) <tbody> </tbody>

<tbody>
</tbody>

 

[brandybartz]

This worked. Thank you

 

[DanteAmor]

Youre welcome