Multiplying and sum 2 data sets

[ViSM]

Hi All,

Just wondering if anyone has a good formula to use to multiply 2 sets of data with different categories?

Data set 1 has countries with 2 sets of values for each country - Upfront and Arrears.

Data set 2 is the % for each country.

What I am trying to do is find a formula that will multiply the % of each country against the 2 sets of values in Data set 1 and sum them up.

Can't explain it very well but I have attached an example.

Thank you very much in advance.

Example.xlsx

What I am trying to achieve is highlighted yellow but the data sets are much larger so I am hoping there is a more simple way instead of manually going through.