Create summary financials based on day and month

Hi

Hoping someone can help me with this problem.

I get a data feed every day and wanted to create a summary of this to track trends over time.

Referring to attached spreadsheet.
- I have created a spredsheet which I plan to copy and data into every day. The worksheet which I have named “data” is where I plan to copy the data values.
- On the summary worksheet I want to divide 2 cells based on the day and month and display the results in the summary sheet based on the 3 products.

I have attached a spreadsheet which has an example of the data and the calculation on the summary sheet. Basically the goal is once I copy the data in every day it automatically calculates the corresponding result in the summary sheet.

Hope someone can help.

Thanks
H