Hi there,
i have a table with a criterion row, a multiplicator row and then some rows of whole numbers for certain calendar weeks.
|Device|Mulitplikator|CW7|CW8|CW9|…|
| A | 100 | 0 | 48 | 96 |…|
| B | 100 | 0 | 12 | 36 |…|
| A | 100 | 0 | 144 | 48 |…|
| A | 100 | 0 | 48 | 96 |…|
i want to count the number of items per calender week of Type “A” (first row) and i need one device per 100 pieces . I also need 1 device if less than 100 pieces are needed while i cannot add different rows to each other. So for example in CW8, there are 48, 144 and 48 pieces in rows 1,3 and 4 which should add up to 1+2+1 = 4 devices “A” in CW8.
Essentially i want to do
"=SUMIF(A1:A4;“A”;ROUNDUP(D1:D4)/100)) "
I tried with just rounding up the values which works for 1 cell (so ROUNDUP(D4/100) ) so i tried;
“=SUM(ROUNDUP(D1:D4/100))”
Creating rows for all calender weeks were i first calculate the roundup and then sum those seems possible but i am looking for a more convenient methods if possible.
but this won’t work. Any ideas?
Thanks in advance and best regards