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
.
.
.
.
30000 rows
.
.
.
In sheet 2 I have already some subtotals calculated by other aplication, but I need to verify the values. So I have something like:
Sheet2
A------------------B---------------------C
Code-------------Total 1-----------------My total
241---------------10770----------------- Here goes my total
120----------------1002------------------Here goes my total
.
.
.
.
This is realy urgent... can you please help me?
Thanks
JK
Bookmarks