Hello Excel People

We have a rather complex array issue we are trying to overcome:

This is the standard array formula we are using to sum various columns according to a single parameters being met, in this case the value $k$6, being within the F column.

=SUM(('EVERYTHING PIVOT'!$F$5:$F$100000=$K$6)*('EVERYTHING PIVOT'!$K$5:$K$100000))

However, we now wish to sum values over that group of dates that is 30 days previous to the latest date in the range.

The values will satisfy this condition in the date column A:

">"&MAX($A$5:$A$100000)-30

However I can't see a way of integrating it into the the first array formula as an additional parameter, as array formulas can only use single values and not ranges..

I there something I am missing here?

Best Regards,

M