Sumproduct getting 0 result

[Akbarov]

Hey Dear comminity,


Can anyone help me to fix what is wrong with my formula?

=SUMPRODUCT(--(EXACT(A2,D2:D426)),L2:L426)


A2 = specific product name

D2:D426 = Yearly total sold products

L2:L426 = Price

I am getting N/A error

[Norie]

Works fine for me, can you upload a workbook with sample data?

[bebo021999]

=SUMPRODUCT(--(EXACT(A2,D2:D426)),L2:L426)
A2 = specific product name
D2:D426 = Yearly total sold products

You is trying to compare a "string" with a number.
Can you upload a worksheet, ot image at least, to have an overview?