if functions nested with index and match functions

[mopo247]

Month	Bill date	Customer Type	Customer	destination	Product type	product	total minutes
june	6/1/2015	Dir	ABB	11360 fx	fx	dd	345
june	2/2/2015	OLO	ABB	11360 mob	mb	tf	89

<tbody>
</tbody>

Rate	fx	MB
$	3	8

<tbody>
</tbody>

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.