Hi there,
I want to know if this can be done, and if yes, I´ll need Your assistance.
First see attached file with sample data.
1) Input data are static and helper columns can be added if needed.
2) Filter will be dynamic range (in attachement is the filter static), and the count of years can be changed on users request. So there could be only 2011, but also 2011+2012, 2012+2013+2014 etc.
3) In col 'J', the is what I know to do, but I do not want to use SUMIF+SUMIF+SUMIF... for each year (the count of years will change througt time as mentioned above).

In my oppinion, an array formula has to be created, but I have no idea how to build it.

So pls, can someone?
Thanks

Regards

M
Data.xlsx