It works! Thank you very much.

Final final question.......how would I add in to this an extra condition that it should only calculate cells where the value in column C DOES NOT say "JPN"?

Thank you...