trouble adding unique value criteria to a formula

[cella]

Hello,
I have an existing formula which works however it is generating duplicate values. Is there a way I can add another criteria that it should only pick out unique values from another column?

=(SUMPRODUCT((Data!$B:$B="Cen: 2015 NewB")*(Data!$Q:$Q>=Summary!$CN322)*(Data!$Q:$Q<=Summary!$CO322)))+(SUMPRODUCT((Data!$B:$B="Cen: 2015 NB-TE")*(Data!$Q:$Q>=Summary!$CN322)*('Rogers Data'!$Q:$Q<=Summary!$CO322))+(SUMPRODUCT((Data!$B:$B="Cen: 2015 In")*(Data!$Q:$Q>=Summary!$CN322)*(Data!$Q:$Q<=Summary!$CO322))))

appreciate your feedback. Thank you.

 

[ExcelGuyDude]

In short, yes... there is

 

[cella]

Great! can you share it ?

 

[ExcelGuyDude]

Can you just add another column that would be a count of the items that are being duplicated. Then you can just add another criteria into your SUMPRODUCT formulas that would check for a one in the "Countif" column.
I'm not sure exactly what your ranges are, as this is a very broad question, but the formula would look something like this:

[B5]=Countif(A$2:A5,A5)

If you drag this formula down column B, it will count the number of instances that the value has occurred at and above the cell.