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

Thanks you very very much. I think his solves my problem, I will have a play with the formula and confirm.

Hi, Just wanted to say thanks for your help. It worked perfectly!!
I will mark as solved.