Qty that drop into a date bucket when I input a date with other criteria

Hi,

This is too hard for me. I do not have any formula.

If you select a date in a Cell and also input with a start qty in another Cell.
It will drop into the date bucket that make daily quantity suppose to count.

Not sure if these could be resolve with Excel Sumif..sum product.. or other matching formulas.

Thanks