Hello Chandoo users! This is a sample of the workbook at hand with most of the sensitive data deleted. I'm relatively new to excel and some of the more complicated syntax formulas are still difficult to understand. I'm using Excel 2007 on Windows.
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, for all cells in a defined 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.
P.S. I'm using Excel in German, I don't know whether or not the differences are autocorrected when opening the spreadsheet with Excel in English. Those include translated operators (i.e sum - summe, if - wenn etc) and all comma separators are semicolons , -> ; If necessary I can translate everything and post it again.
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, for all cells in a defined 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.
P.S. I'm using Excel in German, I don't know whether or not the differences are autocorrected when opening the spreadsheet with Excel in English. Those include translated operators (i.e sum - summe, if - wenn etc) and all comma separators are semicolons , -> ; If necessary I can translate everything and post it again.
