Sumif sold certain product in each month of the year

[shmemushi]

Hi
I am looking for a formula to sum sales of x product for each month.

Colum a
Product1
Product2
Product1
Product3

Colum b sold amount
12
32
23
10

Colum c sold date/month/year
12/may/2017
29/may/2017
16/jun/2017
09/jul/2017

I need a formula to sum all sales of a product in each month.
Any help?
Thanks in advance

[JBeaucaire]

Use a Pivot Table. It will summarize all the data by year and month if you set it up that way.

1) Highlight data
2) Insert Pivot Table
3) PRODUCTS go in the Columns values
4) SOLD goes in the table values
5) Dates go in the Row values

After that - right-click on one of the dates in the resulting summary table and select GROUP BY >>
Group by both Year and Month.

[shmemushi]

Thanks for your reply.
It is not really what i am looking for
I need to see it everytime updated in a diferent sheet or below the main sheet.
Thank you

Use a Pivot Table. It will summarize all the data by year and month if you set it up that way.

1) Highlight data
2) Insert Pivot Table
3) PRODUCTS go in the Columns values
4) SOLD goes in the table values
5) Dates go in the Row values

After that - right-click on one of the dates in the resulting summary table and select GROUP BY >>
Group by both Year and Month.

[oeldere]

You can refresh the pivot table, if you added new data in your inputfile.