How to add numbers on a given date

[barexcel]

Hello-



Thank you in advance for your help with this!
The spreadsheet I have, helps with keeping track of an employee's salary and the funding source(s) used to cover the employee's paycheck.
To avoid issues, an employee needs to have their paycheck supported/covered at 100% from one or multiple funding sources. An issue will happen if an employee only has 50% of their paycheck covered by one or multiple funding sources.
Funding sources are often limited to a specific time range they can be used to support an employee and this is where things get tricky. To help summarize if a paycheck is going to be covered 100% by one or multiple funding sources, I have tried to use the SUMIFS formula but I can't get it to work for me. The formula I need help with is one that will sum up the total amount each paycheck is being supported at, on pay day.

Attached is this spreadsheet, column 'R' is where I have tried to create a formula to show the amount each paycheck is being supported at. Can anyone help me create a formula that will total column 'G' on a given payday column 'Q', from the various funding sources that can be used within a time range column 'H and I'.

Thank you!