re-indexing increments

[Calimer06]

Hello - this is my first post on this forum !

I might not be an excel Master, but I do work a lot with it and on pretty complex formulas, but on this one I feel stuck, close to a solution that eludes me everytime .

I have attached a file with the data and the desired outcome. Basically I have increments based on a unit in the laid out form and I would like to have them in a compact form (precisely this one ... unfortunatly).

Maybe someone here could have a look and give me a second opinion ?

Thank you very much

 

[Calimer06]

Solved it: added a Numbervalue formula around the whole matrix - it works ! Thank you both so much for your help

 

[markmzz]

Solved it: added a Numbervalue formula around the whole matrix - it works ! Thank you both so much for your help

Try this array formula:

=IF(M3="","",SUM(INDEX(IF($A$3:$A$55>L3,IF($A$3:$A$55<=M3,$B$3:$I$55)),,MATCH(N$2,$B$2:$I$2,0))))

Markmzz