How to multiply cells belonging to specific month of a year and company name?

[kursenkoalla]

My input is daily data from 2001 to 2016 for 200 companies.
The output is monthly data (Here I calculate "Product" in June, 2000 = product of all "(RD/100+1)" in June 2000:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Company[/TD]
[TD]Price Close[/TD]
[TD]Date[/TD]
[TD]Daily Returns[/TD]
[TD]Daily Data[/TD]
[TD][/TD]
[TD][/TD]
[TD]Company[/TD]
[TD]Date [/TD]
[TD]Monthly Data[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]XOM[/TD]
[TD]41,46[/TD]
[TD]01.06.2000[/TD]
[TD]-0,45[/TD]
[TD]0,99[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]30.06.2000[/TD]
[TD]0,94[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]XOM[/TD]
[TD]39,59[/TD]
[TD]02.06.2000[/TD]
[TD]-4,52[/TD]
[TD]0,95[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]31.07.2000[/TD]
[TD]1,02[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]XOM[/TD]
[TD]39,66[/TD]
[TD]03.06.2000[/TD]
[TD]0,16[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]31.08.2000[/TD]
[TD]1,01[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]XOM[/TD]
[TD]41,16[/TD]
[TD]04.06.2000[/TD]
[TD]3,78[/TD]
[TD]1,04[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]30.09.2000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]XOM[/TD]
[TD]40,56[/TD]
[TD]05.06.2000[/TD]
[TD]-1,44[/TD]
[TD]0,99[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]31.10.2000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]XOM[/TD]
[TD]40,03[/TD]
[TD]06.06.2000[/TD]
[TD]-1,31[/TD]
[TD]0,99[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]30.11.2000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]XOM[/TD]
[TD]39,59[/TD]
[TD]07.06.2000[/TD]
[TD]-1,09[/TD]
[TD]0,99[/TD]
[TD][/TD]
[TD][/TD]
[TD]XOM[/TD]
[TD]31.12.2000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Here (in J3): =PRODUCT(E3:E24)
Here (in J4): =PRODUCT(E25:E68) etc.

The problem is that I have to enter the formula for each month for each company to compute this. Is there a more efficient solution to the problem? P.S. Number of days each month/year/for each company isn't the same.

 

[Dr. Demento]

Welcome to the board, kursenkoalla!

I suppose this gets you started (https://www.mrexcel.com/forum/excel-questions/405617-need-productif-solution.html) but I would imagine that you would like it so the month and year values were not hardcoded. I'd have to put some thought into that.

However, a pivot table using product value field might serve your purpose as well.