Dynamic SUMPRODUCT

I have received some wonderful help on this forum and now am hoping to take it a step further.

I have attached a sample book here. The function in cells B7 and B8 is what I have to add up the hours per task. This is what I needed and got from here. I now would like to extend this to get the dollar value per task. I was hoping it would be as simple as adding a second array to the SUMPRODUCT function but that didn't work. I have put in the results I am looking for manually in cells C7 and C8. Is there a way to do this dynamically, integrating the functions in cells B7 and B8?

As an aside, what I'm ultimately looking for is the table in A20:C22 (dynamic of course). I want to have the cost per task per month, using the hours entered per week per task above.

Any help is greatly appreciated. Thank you in advance.

@JohnTopley Thank you so much. This was amazing!!! It is exactly what I was looking for.

Related to improving the data, I'm all for improvements. Although I don't know how because I need to give the user (the PM for a project in this case) the ability to set the hours per week per task for an employee (replaced in the sample data by job class for obvious reasons). So other inputs in the case would be the start and end date which the PM would set, which would build the time frame for the project. Then they would add employees in each row, with their job class and their rate. The tasks for each employee per week would be chosen via a drop down menu, and the PM would then decide how many hours that week a person will work on a specific task. This then (through your genius) would build the forecasted amounts per task per month.

So again, I am all for improvements and know completely that I am not the best at Excel and this could probably be streamlined. However, I can't see it at the moment where it would give the PM the ability to see the data they require to build a forecast for the project.

Thanks again for your help, @JohnTopley. Truly amazing and I love this forum for people like you.

I obviously I can only judge on what I see in your workbook and obviously have no idea what happens in the "background".

Your feedback indicates a process which appears somewhat more complex than is apparent from your workbook so with such a limited view I cannot comment further other to say a more "standard" format would be a Date column, Project Column, "data" (hours ?) column rather going across a row in the "blocks" you have.

Glad to have helped and thank you for the rep.