Look up in two sheets and populate SUM in third sheet - stuck up need help - xls 2007

Calling all experts for help please. Been stuck up for hours now.
I have three sheets in an xls.

Sheet 1
EMP-Weekly Sal
EMP ID || Week || Salary
1 || 1 || 1000
2 || 1 || 1500
3 || 1 || 2000
1 || 2 || 1500
2 || 2 || 1500
3 || 2 || 1500

Sheet 2
EMP-Country-Allocation
EMP ID || CNTRY || ALLOCATION
1 || IND || 0.5
1 || MLY || 0.5
2 || IND || 0.3
2 || SGP || 0.7
3 || IND || 0.4
3 || SGP || 0.5
3 || MLY || 0.1

Sheet 3
Country-SAL-Expenses
COUNTRY || Expenses
IND
SGP
MLY


Now in Sheet 3, expenses column, I need the totals of expenses country wise.
Basically output would be
Sheet 3
Country-SAL-Expenses
COUNTRY || Expenses
IND || 3550
SGP || 3850
MLY || 1600


Similar sample xl attached for reference as well.

Regards
Lily

Hi deepak
Each country should be considered based on employees allocation in the specific country.
0.4 would mean 40% of his salary will be borne by that country.

Thanks
Lily

Hi Dilip

In the example, we need to check the salaries of the employees, then check their allocation in another sheet to find out for which country they clocked the effort as one employee can be part of two countries' projects.
Lastly the expenses needed are at country level - so need to check the emp salary, her allocation in the country and derive the expense incurred per country. All of this in one formula.

Like for my example - For India
EMP 1 - 0.25 allocation which means IND expense is 25% of his salary which is 1000+ 1500 = 25% of 2500 = 625
EMP 2 - 0.5 allocation which means IND expense is 50% of his salary which is 1500 + 1500 = 50% of 3000 = 1500
EMP 3 - 0.6 allocation which means IND expense is 60% of his salary which is 1500 + 2000 = 60% of 3500 = 2100.

So total expense for India - 4225.

Hope this clarifies.

Thanks
Lily

Hi Dilip

Both the entries should be considered.
Employee Salary may be due to two projects of that region he is working and clocking separately or you can also consider, employee clocking across two weeks differently, so in effect both the entries to be added up and are not duplicate but multiple entries for the employee.

Regards
Lily