Search and sum if equal

[Berna11]

Good evening, you want to connote column A codes with column C and add the respective column values B and D if the codes are upright in case only one of them returns the value of the existing one and not # N / D
Example line 3 of the attached file must give 2
The formula I'm using is not good
Thank you

[Special-K]

Try

=IFERROR(VLOOKUP(A2,$A$2:$B$30,2,0),0)+IFERROR(VLOOKUP(A2,$C$2:$D$56957,2,0),0)
and copy down the column

[63falcondude]

Try

=SUM(SUMIF(C:C,A2,D:D),SUMIF(A:A,A2,B:B))

[Berna11]

Hi boy
Both solutions are perfect
Thanks a lot for the quick solution
you are great.