Zelle | Formel |
I4 | =SUMMEWENN($F$2:$F$100;H4;$C$2:$C$100) |
I5 | =SUMMEWENN($F$2:$F$100;H5;$C$2:$C$100) |
C6 | =+C2*D6 |
E6 | =+C3+30 |
F6 | =KÜRZEN((E6-WOCHENTAG(E6;2)-DATUM(JAHR(E6+4-WOCHENTAG(E6;2)); 1;-10))/7)&". KW" |
I6 | =SUMMEWENN($F$2:$F$100;H6;$C$2:$C$100) |
C7 | =+C2*D7 |
E7 | =+C3+60 |
F7 | =KÜRZEN((E7-WOCHENTAG(E7;2)-DATUM(JAHR(E7+4-WOCHENTAG(E7;2)); 1;-10))/7)&". KW" |
I7 | =SUMMEWENN($F$2:$F$100;H7;$C$2:$C$100) |
C8 | =+C2*D8 |
E8 | =+C3+90 |
F8 | =KÜRZEN((E8-WOCHENTAG(E8;2)-DATUM(JAHR(E8+4-WOCHENTAG(E8;2)); 1;-10))/7)&". KW" |
I8 | =SUMMEWENN($F$2:$F$100;H8;$C$2:$C$100) |
C9 | =+C2*D9 |
E9 | =+C3+180 |
F9 | =KÜRZEN((E9-WOCHENTAG(E9;2)-DATUM(JAHR(E9+4-WOCHENTAG(E9;2)); 1;-10))/7)&". KW" |
I9 | =SUMMEWENN($F$2:$F$100;H9;$C$2:$C$100) |
I10 | =SUMMEWENN($F$2:$F$100;H10;$C$2:$C$100) |
I11 | =SUMMEWENN($F$2:$F$100;H11;$C$2:$C$100) |
I12 | =SUMMEWENN($F$2:$F$100;H12;$C$2:$C$100) |
I13 | =SUMMEWENN($F$2:$F$100;H13;$C$2:$C$100) |
I14 | =SUMMEWENN($F$2:$F$100;H14;$C$2:$C$100) |
I15 | =SUMMEWENN($F$2:$F$100;H15;$C$2:$C$100) |
C16 | =+C12*D16 |
E16 | =+C13+30 |
F16 | =KÜRZEN((E16-WOCHENTAG(E16;2)-DATUM(JAHR(E16+4-WOCHENTAG(E16;2)); 1;-10))/7)&". KW" |
I16 | =SUMMEWENN($F$2:$F$100;H16;$C$2:$C$100) |
C17 | =+C12*D17 |
E17 | =+C13+60 |
F17 | =KÜRZEN((E17-WOCHENTAG(E17;2)-DATUM(JAHR(E17+4-WOCHENTAG(E17;2)); 1;-10))/7)&". KW" |
I17 | =SUMMEWENN($F$2:$F$100;H17;$C$2:$C$100) |
C18 | =+C12*D18 |
E18 | =+C13+90 |
F18 | =KÜRZEN((E18-WOCHENTAG(E18;2)-DATUM(JAHR(E18+4-WOCHENTAG(E18;2)); 1;-10))/7)&". KW" |
I18 | =SUMMEWENN($F$2:$F$100;H18;$C$2:$C$100) |
C19 | =+C12*D19 |
E19 | =+C13+180 |
F19 | =KÜRZEN((E19-WOCHENTAG(E19;2)-DATUM(JAHR(E19+4-WOCHENTAG(E19;2)); 1;-10))/7)&". KW" |
I19 | =SUMMEWENN($F$2:$F$100;H19;$C$2:$C$100) |
I20 | =SUMMEWENN($F$2:$F$100;H20;$C$2:$C$100) |
I21 | =SUMMEWENN($F$2:$F$100;H21;$C$2:$C$100) |
I22 | =SUMMEWENN($F$2:$F$100;H22;$C$2:$C$100) |
I23 | =SUMMEWENN($F$2:$F$100;H23;$C$2:$C$100) |
I24 | =SUMMEWENN($F$2:$F$100;H24;$C$2:$C$100) |
I25 | =SUMMEWENN($F$2:$F$100;H25;$C$2:$C$100) |
C26 | =+C22*D26 |
E26 | =+C23+30 |
F26 | =KÜRZEN((E26-WOCHENTAG(E26;2)-DATUM(JAHR(E26+4-WOCHENTAG(E26;2)); 1;-10))/7)&". KW" |
I26 | =SUMMEWENN($F$2:$F$100;H26;$C$2:$C$100) |
C27 | =+C22*D27 |
E27 | =+C23+60 |
F27 | =KÜRZEN((E27-WOCHENTAG(E27;2)-DATUM(JAHR(E27+4-WOCHENTAG(E27;2)); 1;-10))/7)&". KW" |
I27 | =SUMMEWENN($F$2:$F$100;H27;$C$2:$C$100) |
C28 | =+C22*D28 |
E28 | =+C23+90 |
F28 | =KÜRZEN((E28-WOCHENTAG(E28;2)-DATUM(JAHR(E28+4-WOCHENTAG(E28;2)); 1;-10))/7)&". KW" |
I28 | =SUMMEWENN($F$2:$F$100;H28;$C$2:$C$100) |
C29 | =+C22*D29 |
E29 | =+C23+180 |
F29 | =KÜRZEN((E29-WOCHENTAG(E29;2)-DATUM(JAHR(E29+4-WOCHENTAG(E29;2)); 1;-10))/7)&". KW" |
I29 | =SUMMEWENN($F$2:$F$100;H29;$C$2:$C$100) |
I30 | =SUMMEWENN($F$2:$F$100;H30;$C$2:$C$100) |
I31 | =SUMMEWENN($F$2:$F$100;H31;$C$2:$C$100) |
I32 | =SUMMEWENN($F$2:$F$100;H32;$C$2:$C$100) |
I33 | =SUMMEWENN($F$2:$F$100;H33;$C$2:$C$100) |
I34 | =SUMMEWENN($F$2:$F$100;H34;$C$2:$C$100) |
I35 | =SUMMEWENN($F$2:$F$100;H35;$C$2:$C$100) |
I36 | =SUMMEWENN($F$2:$F$100;H36;$C$2:$C$100) |
I37 | =SUMMEWENN($F$2:$F$100;H37;$C$2:$C$100) |
I38 | =SUMMEWENN($F$2:$F$100;H38;$C$2:$C$100) |
I39 | =SUMMEWENN($F$2:$F$100;H39;$C$2:$C$100) |
I40 | =SUMMEWENN($F$2:$F$100;H40;$C$2:$C$100) |
I41 | =SUMMEWENN($F$2:$F$100;H41;$C$2:$C$100) |
I42 | =SUMMEWENN($F$2:$F$100;H42;$C$2:$C$100) |
I43 | =SUMMEWENN($F$2:$F$100;H43;$C$2:$C$100) |
I44 | =SUMMEWENN($F$2:$F$100;H44;$C$2:$C$100) |
I45 | =SUMMEWENN($F$2:$F$100;H45;$C$2:$C$100) |