if functions nested with index and match functions

[mopo247]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Bill date[/TD]
[TD]Customer Type[/TD]
[TD]Customer[/TD]
[TD]destination[/TD]
[TD]Product type[/TD]
[TD]product[/TD]
[TD]total minutes[/TD]
[/TR]
[TR]
[TD]june[/TD]
[TD]6/1/2015[/TD]
[TD]Dir[/TD]
[TD]ABB[/TD]
[TD]11360 fx[/TD]
[TD]fx[/TD]
[TD]dd[/TD]
[TD]345[/TD]
[/TR]
[TR]
[TD]june[/TD]
[TD]2/2/2015[/TD]
[TD]OLO[/TD]
[TD]ABB[/TD]
[TD]11360 mob[/TD]
[TD]mb[/TD]
[TD]tf[/TD]
[TD]89[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Rate[/TD]
[TD]fx[/TD]
[TD]MB[/TD]
[/TR]
[TR]
[TD]$[/TD]
[TD]3[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]



I receive a weekly report that shows the daily performance of multiple customers as shown within the first table.

i would like to create a formula in a summary worksheet that enables me to show the financial gains for the week for each customer. by multiplying the rates column by the total minutes.
I would like the summary sheet to return following:

1), the last day of the week -for the weekly report and subsequently the month in order to show the monthly performance.
2),Customer type,
3),customer
4), Destination
5), Product type,
6) financial performance (where the total minutes are multiplied by the rates based on the product type)
​

I have tried using an index and match function nested in an if function and tried to squeeze another if function to multiply the minutes by the rates.

I am simply lost on getting any formula to work.

Please help me.