As per criteria return a total amount with multiplying a rates by actual hours

Hi,


Required a formula help for in summary sheet as per criteria return a total amount with multiplying a rates by actual hours values avail in column D:H.

Sample sheet with expected results enclosed.



Thanks for your help.