I've been lurking around here for a while and have gotten some good help by searching through other posts but need some assistance on a spreadsheet I'm developing.

The purpose of the sheet is to allow entry of an activity name, start date, finish date, and required man hours to complete for some high level resource planning. In the document attached below you can see I've created two tabs. The first is 'Daily Spread' where cells H7:HQ7 contain the workday (Monday - Friday), columns A-E contain the activity name, start, finish, total and daily man hours. The green section at the top contains resource numbers, daily hours, and so on to support conditional formatting to identify over-allocations and the need for more full time employees. I figured out (with help from posts here) how to spread the activity man hours linearly across the work days for each activities start and finish. Those values are contained in H8:HQ18. I am only going to be spreading costs linearly so no need for fancy curves (i.e. bell, front loaded, back loaded, etc.).

The second tab, 'Weekly Spread' was created to try and sum the daily spread values for each activity into a weekly total. The dates on the weekly spread tab are the last working day of each week (Friday). For examlple, on Activity 1, G8 should total 116. And so on for each week and activity.

My questions are:

1. Does anyone have an idea how to sum the daily man hour totals into a weekly total on the weekly spread tab?
2. Is there a way to totally cut out the daily spread and get down to a single weekly spread tab? I attempted to do this at first but couldn't make it work.

Thanks for your help and ask any questions you need.

Updated Man Hour Spreader estimator tool.xlsx