Count/Sum based on another column date range/value

Dear Experts,

Good Day, How are you doing all? Hope all are safe & healthy in this pandemic situation.

I am facing problem to make reports based on raw data. I did some experiment to do it but I failed. Here I have attached the sheet for your understating & and explain inside what required in my reporting. Hope I could get some help from you.

Thanks in advance.

Regards,
Iqbal