Sum product formula over 2 sheets

Hello All,


I have a spreadsheet that records product each day and we also need a monthly figure. I currently have =SUMPRODUCT(--(MONTH($B$2:$B$100)=ROWS(H$3:H3)),$D$2:$D$100) in H3 on sheet 1 (Rig 1 Daily) so the figure for January is recorded automatically, however, I want to move this data and formula to sheet 2 (Rig 1 Monthly). Anyone know how I would amend it please so I get the same results on the second sheet?

Many Thanks,

May be this.
In B2 copy down.

Formula:

Please Login or Register  to view this content.

Thanks so much that worked perfectly!

Just noticed 1 potential problem though, its being recorded from 26/12/22 - 07/01/24 so, for example, all of Jan 24's figures will be recorded in the Jan 23 monthly figure if that makes sense. Is there an easy fix to pull the data from month and year instead of just month?
If there is that would really be the cherry on top but if not we can always change the recorded dates
New spreadsheet uploaded on original post with Jan 24 dates.
Thanks

Since same week numbers are repeating in all years It is better Mention the year in the table. Pl see file.
In C2 copy down.

Formula:

Please Login or Register  to view this content.

Try

Formula:

Please Login or Register  to view this content.

year in G1 i.e 2023

Post #4 formula corrected.

Please Login or Register  to view this content.