Formula when drag should use horizontal values.

Hi,
Please see the attached workbook. Allocation summary has a daily hours section wherein the allocated column has a logical formula, when the date selected from the drop down in the B column should provide a sum of hours for a particular person from the monthly workload sheet.

I am not able to get this formula for horizontal values. Can anyone help with this issue.