Date filter formula

[MonicaK]

Hi,

I have the working formula:
=IFERROR(LET(a,FILTER(CHOOSECOLS(Table1,18),(Table1[Type]="General")*(Table1[Colour]="Red")*(Table1[Size]="Large")*(Table1[Name]=$A7)),SUM(a)),0)+(IFERROR(LET(b,FILTER(CHOOSECOLS(Table1,20),(Table1[Type]="General")*(Table1[Colour]="Red")*(Table1[Size]="Large")*(Table1[Name]=$A7)),SUM(b)),0)+(IFERROR(LET(c,FILTER(CHOOSECOLS(Table1,22),(Table1[Type]="General")*(Table1[Colour]="Red")*(Table1[Size]="Large")*(Table1[[3 ]]=$A7)),SUM(c)),0)))

I know it's messy but it works for how the fixed data is set out. However, I am attempting to add into it a date filter. The below formula works alone:
=FILTER(Table1[Date],(Table1[Date]>=DATE(2024,1,1))*(Table1[Date]<=DATE(2024,1,31)))

but I just can't seem to integrate it anyway into the main formula for each of the sums (a, b and c). Any ideas would be gratefully appreciated.

Thanks,

 

[Fluff]

For the 3rd part of your formula looking at col 22 is A7 meant to be matching the Name column as per the other 2, or is it correct matching a column called 3?