| verwendete Formeln |
| Zelle | Formel | Bereich |
| P25 | =+P4 | |
| Q25 | =+Q4 | |
| R25 | =+R4 | |
| S25 | =+S4 | |
| T25 | =+T4 | |
| P26 | =WENN(UND(P$4>=$I5;P$4<=$J5);$L5;"") | |
| Q26 | =WENN(UND(Q$4>=$I5;Q$4<=$J5);$L5*ANZAHL($P26:Q26);"") | |
| R26 | =WENN(UND(R$4>=$I5;R$4<=$J5);$L5*ANZAHL($P26:R26);"") | |
| S26 | =WENN(UND(S$4>=$I5;S$4<=$J5);$L5*ANZAHL($P26:S26);"") | |
| T26 | =WENN(UND(T$4>=$I5;T$4<=$J5);$L5*ANZAHL($P26:T26);"") | |
| P27 | =WENN(UND(P$4>=$I6;P$4<=$J6);$L6;"") | |
| Q27 | =WENN(UND(Q$4>=$I6;Q$4<=$J6);$L6*ANZAHL($P27:Q27);"") | |
| R27 | =WENN(UND(R$4>=$I6;R$4<=$J6);$L6*ANZAHL($P27:R27);"") | |
| S27 | =WENN(UND(S$4>=$I6;S$4<=$J6);$L6*ANZAHL($P27:S27);"") | |
| T27 | =WENN(UND(T$4>=$I6;T$4<=$J6);$L6*ANZAHL($P27:T27);"") | |
| P28 | =WENN(UND(P$4>=$I7;P$4<=$J7);$L7;"") | |
| Q28 | =WENN(UND(Q$4>=$I7;Q$4<=$J7);$L7*ANZAHL($P28:Q28);"") | |
| R28 | =WENN(UND(R$4>=$I7;R$4<=$J7);$L7*ANZAHL($P28:R28);"") | |
| S28 | =WENN(UND(S$4>=$I7;S$4<=$J7);$L7*ANZAHL($P28:S28);"") | |
| T28 | =WENN(UND(T$4>=$I7;T$4<=$J7);$L7*ANZAHL($P28:T28);"") | |
| P29 | =WENN(UND(P$4>=$I8;P$4<=$J8);$L8;"") | |
| Q29 | =WENN(UND(Q$4>=$I8;Q$4<=$J8);$L8*ANZAHL($P29:Q29);"") | |
| R29 | =WENN(UND(R$4>=$I8;R$4<=$J8);$L8*ANZAHL($P29:R29);"") | |
| S29 | =WENN(UND(S$4>=$I8;S$4<=$J8);$L8*ANZAHL($P29:S29);"") | |
| T29 | =WENN(UND(T$4>=$I8;T$4<=$J8);$L8*ANZAHL($P29:T29);"") | |
| P30 | =WENN(UND(P$4>=$I9;P$4<=$J9);$L9;"") | |
| Q30 | =WENN(UND(Q$4>=$I9;Q$4<=$J9);$L9*ANZAHL($P30:Q30);"") | |
| R30 | =WENN(UND(R$4>=$I9;R$4<=$J9);$L9*ANZAHL($P30:R30);"") | |
| S30 | =WENN(UND(S$4>=$I9;S$4<=$J9);$L9*ANZAHL($P30:S30);"") | |
| T30 | =WENN(UND(T$4>=$I9;T$4<=$J9);$L9*ANZAHL($P30:T30);"") | |
| P31 | =WENN(UND(P$4>=$I10;P$4<=$J10);$L10;"") | |
| Q31 | =WENN(UND(Q$4>=$I10;Q$4<=$J10);$L10*ANZAHL($P31:Q31);"") | |
| R31 | =WENN(UND(R$4>=$I10;R$4<=$J10);$L10*ANZAHL($P31:R31);"") | |
| S31 | =WENN(UND(S$4>=$I10;S$4<=$J10);$L10*ANZAHL($P31:S31);"") | |
| T31 | =WENN(UND(T$4>=$I10;T$4<=$J10);$L10*ANZAHL($P31:T31);"") | |
| P32 | =WENN(UND(P$4>=$I11;P$4<=$J11);$L11;"") | |
| Q32 | =WENN(UND(Q$4>=$I11;Q$4<=$J11);$L11*ANZAHL($P32:Q32);"") | |
| R32 | =WENN(UND(R$4>=$I11;R$4<=$J11);$L11*ANZAHL($P32:R32);"") | |
| S32 | =WENN(UND(S$4>=$I11;S$4<=$J11);$L11*ANZAHL($P32:S32);"") | |
| T32 | =WENN(UND(T$4>=$I11;T$4<=$J11);$L11*ANZAHL($P32:T32);"") | |
| P33 | =WENN(UND(P$4>=$I12;P$4<=$J12);$L12;"") | |
| Q33 | =WENN(UND(Q$4>=$I12;Q$4<=$J12);$L12*ANZAHL($P33:Q33);"") | |
| R33 | =WENN(UND(R$4>=$I12;R$4<=$J12);$L12*ANZAHL($P33:R33);"") | |
| S33 | =WENN(UND(S$4>=$I12;S$4<=$J12);$L12*ANZAHL($P33:S33);"") | |
| T33 | =WENN(UND(T$4>=$I12;T$4<=$J12);$L12*ANZAHL($P33:T33);"") | |
| P34 | =WENN(UND(P$4>=$I13;P$4<=$J13);$L13;"") | |
| Q34 | =WENN(UND(Q$4>=$I13;Q$4<=$J13);$L13*ANZAHL($P34:Q34);"") | |
| R34 | =WENN(UND(R$4>=$I13;R$4<=$J13);$L13*ANZAHL($P34:R34);"") | |
| S34 | =WENN(UND(S$4>=$I13;S$4<=$J13);$L13*ANZAHL($P34:S34);"") | |
| T34 | =WENN(UND(T$4>=$I13;T$4<=$J13);$L13*ANZAHL($P34:T34);"") | |
| P35 | =WENN(UND(P$4>=$I14;P$4<=$J14);$L14;"") | |
| Q35 | =WENN(UND(Q$4>=$I14;Q$4<=$J14);$L14*ANZAHL($P35:Q35);"") | |
| R35 | =WENN(UND(R$4>=$I14;R$4<=$J14);$L14*ANZAHL($P35:R35);"") | |
| S35 | =WENN(UND(S$4>=$I14;S$4<=$J14);$L14*ANZAHL($P35:S35);"") | |
| T35 | =WENN(UND(T$4>=$I14;T$4<=$J14);$L14*ANZAHL($P35:T35);"") | |
| P36 | =WENN(UND(P$4>=$I15;P$4<=$J15);$L15;"") | |
| Q36 | =WENN(UND(Q$4>=$I15;Q$4<=$J15);$L15*ANZAHL($P36:Q36);"") | |
| R36 | =WENN(UND(R$4>=$I15;R$4<=$J15);$L15*ANZAHL($P36:R36);"") | |
| S36 | =WENN(UND(S$4>=$I15;S$4<=$J15);$L15*ANZAHL($P36:S36);"") | |
| T36 | =WENN(UND(T$4>=$I15;T$4<=$J15);$L15*ANZAHL($P36:T36);"") | |
| P37 | =WENN(UND(P$4>=$I16;P$4<=$J16);$L16;"") | |
| Q37 | =WENN(UND(Q$4>=$I16;Q$4<=$J16);$L16*ANZAHL($P37:Q37);"") | |
| R37 | =WENN(UND(R$4>=$I16;R$4<=$J16);$L16*ANZAHL($P37:R37);"") | |
| S37 | =WENN(UND(S$4>=$I16;S$4<=$J16);$L16*ANZAHL($P37:S37);"") | |
| T37 | =WENN(UND(T$4>=$I16;T$4<=$J16);$L16*ANZAHL($P37:T37);"") | |
| P38 | =WENN(UND(P$4>=$I17;P$4<=$J17);$L17;"") | |
| Q38 | =WENN(UND(Q$4>=$I17;Q$4<=$J17);$L17*ANZAHL($P38:Q38);"") | |
| R38 | =WENN(UND(R$4>=$I17;R$4<=$J17);$L17*ANZAHL($P38:R38);"") | |
| S38 | =WENN(UND(S$4>=$I17;S$4<=$J17);$L17*ANZAHL($P38:S38);"") | |
| T38 | =WENN(UND(T$4>=$I17;T$4<=$J17);$L17*ANZAHL($P38:T38);"") | |
| P39 | =WENN(UND(P$4>=$I18;P$4<=$J18);$L18;"") | |
| Q39 | =WENN(UND(Q$4>=$I18;Q$4<=$J18);$L18*ANZAHL($P39:Q39);"") | |
| R39 | =WENN(UND(R$4>=$I18;R$4<=$J18);$L18*ANZAHL($P39:R39);"") | |
| S39 | =WENN(UND(S$4>=$I18;S$4<=$J18);$L18*ANZAHL($P39:S39);"") | |
| T39 | =WENN(UND(T$4>=$I18;T$4<=$J18);$L18*ANZAHL($P39:T39);"") | |
| P40 | =WENN(UND(P$4>=$I19;P$4<=$J19);$L19;"") | |
| Q40 | =WENN(UND(Q$4>=$I19;Q$4<=$J19);$L19*ANZAHL($P40:Q40);"") | |
| R40 | =WENN(UND(R$4>=$I19;R$4<=$J19);$L19*ANZAHL($P40:R40);"") | |
| S40 | =WENN(UND(S$4>=$I19;S$4<=$J19);$L19*ANZAHL($P40:S40);"") | |
| T40 | =WENN(UND(T$4>=$I19;T$4<=$J19);$L19*ANZAHL($P40:T40);"") | |
| P41 | =WENN(UND(P$4>=$I20;P$4<=$J20);$L20;"") | |
| Q41 | =WENN(UND(Q$4>=$I20;Q$4<=$J20);$L20*ANZAHL($P41:Q41);"") | |
| R41 | =WENN(UND(R$4>=$I20;R$4<=$J20);$L20*ANZAHL($P41:R41);"") | |
| S41 | =WENN(UND(S$4>=$I20;S$4<=$J20);$L20*ANZAHL($P41:S41);"") | |
| T41 | =WENN(UND(T$4>=$I20;T$4<=$J20);$L20*ANZAHL($P41:T41);"") | |