Thanks for your reply, but it didn't work. Maybe I did some
confusion...

In sheet 1 I have something like 30000 codes and values.
In sheet 2 I have some subtotals of the codes but these subtotals were
calculated in other place (an aplication). Now I need to verify that
the results are correct. So I need to sum the values of sheet 1 if the
right(code,3) is equal to the sheet 2 code. I need to have this ready
in 1 hour... can anybody please help me??

Thanks

JK


--
jamkul
------------------------------------------------------------------------
jamkul's Profile: http://www.excelforum.com/member.php...o&userid=36561
View this thread: http://www.excelforum.com/showthread...hreadid=563105