Hello everyone, this is my sheet Jd6uTNV.png. Basically what I need is a formula that sums and/or multiplies (depending on whether it's easier to get done with the pivot table at hand or the small L:O-table) the rows in A:H corresponding to the correct description. The summing has to be done column-by-column, if I can put it that way, and the result should be 6 cells wide.

There can be more or less cells populated in the L:O columns and they will change at least once per week if not more often. And then the week numbers (Kalendar Woche/KW) themselves are going to change as the weeks pass by. The same goes for the pivot-variant. I really don't even know how pivot tables interact with formulas in regards of how they change cell-values with every drop-down menu.

Thanks in advance.