SUMIFS to aggregate hours in scheduling

Dear Excel Gurus

I am trying to aggregate hours for 3 projects over their lifespan in a calendar year.

Each project starts and ends at different periods.

I have a table for the inputs that has the project ID, job hours, and the project's timeframe (expressed in months) from the period it begins and ends.

For example: For Project B, the job will start in month #1 and will end in month #3, which means budgeted hours will need to be scheduled for months 1,2 and 3.

I need to sum up the budgeted hours for all scheduled projects relative to the months they start and end.

I am using a SUMIFS() formula and, for the most part, I feel it's directionally correct. However, when I set the conditions to sum hours relative to the relevant range of months, greater than and less than, it fails.

Screenshots and problem statement are attached.

I hardcoded the expected results for guidance and my SUMIFS() formula is also included.

Thank You Al!