SUMPRODUCT with date restrictions

You're making life hard with your sheet layout and data types, concatenating initial data is seldom a good idea, nor is merging cells.

This is a bit of a guddled compromise, see if it returns the results you want.
If it does we can try to simplify the process.