Iterate Through an Array of Values to Determine SUMPRODUCT?

Hello all,

I'm wondering if this situation is possible. Essentially, I have a SUMPRODUCT that I want to compute for multiple years. For example, for 2022, I'd have the following:

Formula:

Please Login or Register  to view this content.

I have multiple years that I want to sum up, so in order to get my desired result, I'd have to sum this formula multiple times for every year:

Formula:

Please Login or Register  to view this content.

And so on. I was wondering if there is any way to add the desired years to an array and have the formula written only one time, for example, something like this:

Formula:

Please Login or Register  to view this content.

This formula doesn't work because the amount of items in a does not equal the range for Table1[Year] or Table2[Date]. Is something like this even possible?

Please see the yellow ribbon above and attach a sample workbook along with desired results.

Hi Glenn,

Sorry about that, I've updated my version to M365 so I have access to all those fun array formulas. I apologize but I'm currently blocked from uploading files onto the website. I can attach a picture of a sheet if that helps illustrate my question more clearly.