Display Single Value for Multiple Outcomes of a Sumproduct formula

Hi all,

My name is Rob and I need some help.

I have a sumproduct formula which matches with two identical values according to the parameters set. However, on the resulting cell, it adds the two values together (e.g. where the two results are both 1, it places 2).

I would like it to return just one value (either of the two identical values) in the resulting cell.

I would be very thankful if you experts out there could educate me on how I can achieve this!

Thanking in advance,

Rob.

Hi Rob,

Can you post a sample with expected output?

Regards,