Fomula required to calculate and summarise qty's between a start and finish date

Good Morning, I am really scratching my head here with a formula I need to summarise numbers of resource demand per day from a schedule with start and finish dates. I have attached an example excel document - I hope someone can help me?.

In table 1 I have a schedule to Resource, Start Date and finish date then qty. In table 2 I simply want it to create running totals per day - I hope it pretty self explanatory?.

Thanks a lot in advance.

Quote from Haseeb A

Hello Freddy,

Try:

=SUMIFS(E$4:E$6,C$4:C$6,"<="&H4,D$4:D$6,">="&H4)

Absolutely bang on Haseeb - appreciate that so much.