SUMIFS Question

[JD_Excels]

I am trying to do a sumifs, but Column AD has duplicates, how can i tell this formula i only want unique pitch numbers?

 

[ExceLoki]

try this:

=SUM(UNIQUE(IF('Forecast Validation'!D:D=Sheet1!D6,'Forecast Validation'!AD:AD,"")))

 

[ExceLoki]

thanks for the reply. if this solution works for you, please consider marking it as the solution.