Using SUMIFS to sum a range, but modifying what is summed

Hi there,

I am trying to make a tool that will calculate how many hours each person on a team works each week of a project with several tasks, where only some tasks occur each week and some tasks last more than one week. I have one table with a row for each task and a column for each team member. I have an intermediate table with each week of the project as rows and each task as a column to test whether the task occurs that week.

I am close to the goal of a table with a column for each team member and a row for each week, where the cells contain the sum of all applicable hours (i.e., that task takes place that week). The SUMIFS function sums the hours, but there is one remaining issue. The hours being summed are TOTAL project hours, not weekly hours. How can I use the SUMIFS function to sum the weekly average hours for each applicable task? Screenshots below - the first column in table three contains the output I'm looking for, and I hope to find a formula to replicate this process for each of the other rows (that is, calculate the weekly hours for each task by dividing total task hours by task weeks, THEN summing).

Any thoughts?

Thank you!Original table with tasks, weeks, and total hours per task per personIntermediary table, testing whether each task occurs in a given weekUltimate table, summing all hours that a person will work in a given week. First column is the desired output (total hours for a task/weeks allocated to task, then summed).