index match and sumproduct or sumif on multiple criteria

I need to calculate a sum of Rating on date wise ad placement, rating will be on next sheet for that day; find and match the 'day' & 'timeslot' then divide by 30(its mandatory) and then multiply with spot duration and count of spot from that day.

See the attached file.
m trying to find solution for couple of days already digged many thread but couldn't find any specific solution.

Kindly help me out...

is the answer required for tuesday is 3.71 .. ?
just calculate and tell me..

i have re attached the file with more further explanation.

thanks for replying me..

i have seen the formula u put but it does not gives me the required answer, also it duplicating days and calculating on different cells rather then calculating and adding up in single cell. Requirement is to look into data in table and match time and rating of that day in the data sheet.

i have re attached the file, kindly look into it for further explanation.

No dear, answer for tue is 4.45 and gross sum of all days is 7.34, see the attached file.

Brilliant...
m checking by putting different combination, so far spot on. Wondering how you do it & actually formula is acting upto..
Can you explain? or if this formula has any limitation?
Thanks alot for helping me out..