Sorry for my urgence...

I need to find a way to sum a value if the right 3 digits of a code are
equal to another code in other sheet. Example:

Sheet 1
A------------------B---------------------C
Code-------------Field1----------------Value
0231241---------xxxxxxx---------------10020
0032241---------yyyyyy---------------750
0212120---------zzzzzzz---------------1002