SUMIFS to aggregate hours in scheduling

Wk9128

I appreciate the quick response, unfortunately, I left out a critical element - my apologies. The SUMPRODUCT() will not work if the sizes are uneven between the input table and schedule.
If I add 5 records in the input table or if I repeat two projects in scheduling, the SUMPRODUCT() errors out. If you have another formula, I would be indebted. See picture. Thank you Again ! Al

Pls try this formula

Formula:

Please Login or Register  to view this content.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.

wk9128 -

Again, I am indebted to your help. Your formula works great. So we can mark it SOLVED.

But I was wondering if I can pass one last criteria to the problem, which does help me sum hours should we have multiple budgeted job hours per project.
I tried taking your formula by adding a matrix array formula to sum multiple budgeted jobs hours across each project, and it failed.

Summing varying budgeted job hours per project is actually the reality and complexity of what am dealing with, but I was hoping I could solve it myself after the first problem statement I presented.

Let me know if there is a contribution I can make for your time, but this would be my last wrinkle to the problem?

Updated Picture and Problem worksheet re-posted