Sum If between start date and end date

[simply_shailesh]

I have 2 tables 1st is reference and second output required

1st table is like

StartDate End Date Product Price
1-1-20 3-1-2020 ProductA 1000
1-1-20 31-1-2020 ProductB 1100
4-1-20 5-1-2020 ProductA 1010
6-1-20 20-1-2020 ProductA 990
Contains 25k rows

Second Table

Date Product Price Available
1-1-20 ProductA 1000
3-1-20 ProductB 1100
4-1-20 ProductA 1010
5-1-20 ProductA 1010
7-1-20 ProductA 990
Contain 60k row

Currently i am doing this with index, match with maxifs. But i need arrayformula for google sheets....

Kindly help...

 

[jasonb75]

Please post your existing formula, it is easier for us to convert that to one that works with sheets than to create a new one from a sample that contains no valid references.