convert Sumifs to sumproduct or similar

Hi Everyone

This is my very first post here and I'm wondering if you could help me? I have lost 2 days so far trying to figure this out.

I have this formula that does exactly what I want it to do =SUMIFS('2021'!$AD$15:$AD$493,Dates,">="&F$2,Dates,"<"&EDATE(F$2,1),WalletType, "="&$C4) except when I use the auto filters which I need to manipulate the figures but the values do not adjust. (Dates named range 2021'!$F$15:$F$500) (WalletType named range 2021'!$Ac$15:$Ac$500)

I believe I need to use something similar =SUMPRODUCT(SUBTOTAL(9,OFFSET(2021'!$F$15,ROW(2021'!$F$15:$F$500)-ROW(2021'!$F$15),0))*(2021'!$F$15:$F$500>=$G$10)*(2021'!$F$15:$F$500,<=$G$11)*(2021'!$AD$15:$AD$500)*(2021'!$Ac$15:$Ac$500=c12) but cannot make it work.

I am trying to produce a stock plan for stock items that are going to be). So have created a quick example document to assist my explanation the formulas above are not taken from the example just to clarify

The items are added to the project projections tabs on a year by year basis this will show all the history over time without the list becoming too huge and giving us useful history information. The date is added for when the items are required and the product is selected from a drop down list and a quantity placed in the quantity box next to it.
On the stock requirements tab I want to see the items for each product type by month. The production description on this page also works as a drop-down list for the other tabs. Via a data validation list
I need to collate the totals for each product for the month and show them in the stock requirement form
My intention is to use the orange year drop down box to be able to change the overview to look at the different years.
I need to use data filters on the project projection tabs to manipulate the information on the stock requirements tab.