Please help... only have 20 mins

[jamkul]

Sorry for my urgence...

I need to find a way to sum a value if the right 3 digits of a code ar
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

 

[coa01gsb]

Hi,

Not really got time to check it but won't something along the line
of:

insert a column next to column A in sheet 1 (you can hide it later). i
cell 1 of inserted column write '=right(A1,3)', drag down the rest o
the column

This will retrieve the last three digits of the code in column A.

Then wherever you want the count write '=countif(B2:B3000,241)'.

You could probably do it with the countif function from the start bu
it would be hard