How to match the number then replace with value in Column B then sum

maybe

Please Login or Register  to view this content.

Hi Nilem,
That's perfect and thank you very much for your help.

Regards,
tt3

Sorry for re-open the thread becuase the code is not what I expected:

Hi Nilem:
The code is not working because the value on column B is not alway greader by 4. the value in column B could be any number. Please take a look and advise if possible:

maybe

Please Login or Register  to view this content.

Regards,
tt3

Hi tt3,
try this

Please Login or Register  to view this content.

Hi Nilem,
The code work great but would you please modify a code to start searching "NUMBER" at column I and after and also the fn and Vale now is at Column B & C instead of A & B. Please take a look at sample in attached.

Regards.
tt3

try

Please Login or Register  to view this content.

Hi Nilem,
Thank you very much for you time and help. The SUM from code is wrong b/c code does not sum any number in RED which they're not in column B. Please see sample in attached.

Regards,
tt3

Hi tt,
please check the attached file

Hi Nilem,
Sorry I forgot to mention there's text in cell "C:I" so when I tried your code it works if those cells are empty but if there are text filled in then it does not work. Can you take a look at sample in attached and see:

Regards,
tt3

OK, try again

Please Login or Register  to view this content.

Hi Nilem,
Thank you very much for your time and help.

Regards,
tt3