Zelle | Formel |
D2 | =WENN(A2="";SUMMEWENNS(B:B;A:A;A1;B:B;">0");"") |
D3 | =WENN(A3="";SUMMEWENNS(B:B;A:A;A2;B:B;">0");"") |
D4 | =WENN(A4="";SUMMEWENNS(B:B;A:A;A3;B:B;">0");"") |
D5 | =WENN(A5="";SUMMEWENNS(B:B;A:A;A4;B:B;">0");"") |
D6 | =WENN(A6="";SUMMEWENNS(B:B;A:A;A5;B:B;">0");"") |
C7 | =SUMME(B2:B6) |
D7 | =WENN(A7="";SUMMEWENNS(B:B;A:A;A6;B:B;">0");"") |
D8 | =WENN(A8="";SUMMEWENNS(B:B;A:A;A7;B:B;">0");"") |
D9 | =WENN(A9="";SUMMEWENNS(B:B;A:A;A8;B:B;">0");"") |
D10 | =WENN(A10="";SUMMEWENNS(B:B;A:A;A9;B:B;">0");"") |
D11 | =WENN(A11="";SUMMEWENNS(B:B;A:A;A10;B:B;">0");"") |
D12 | =WENN(A12="";SUMMEWENNS(B:B;A:A;A11;B:B;">0");"") |
D13 | =WENN(A13="";SUMMEWENNS(B:B;A:A;A12;B:B;">0");"") |
D14 | =WENN(A14="";SUMMEWENNS(B:B;A:A;A13;B:B;">0");"") |
C15 | =SUMME(B8:B14) |
D15 | =WENN(A15="";SUMMEWENNS(B:B;A:A;A14;B:B;">0");"") |
D16 | =WENN(A16="";SUMMEWENNS(B:B;A:A;A15;B:B;">0");"") |
D17 | =WENN(A17="";SUMMEWENNS(B:B;A:A;A16;B:B;">0");"") |
C18 | =SUMME(B16:B17) |
D18 | =WENN(A18="";SUMMEWENNS(B:B;A:A;A17;B:B;">0");"") |
D19 | =WENN(A19="";SUMMEWENNS(B:B;A:A;A18;B:B;">0");"") |
C20 | =SUMME(B19) |
D20 | =WENN(A20="";SUMMEWENNS(B:B;A:A;A19;B:B;">0");"") |
D21 | =WENN(A21="";SUMMEWENNS(B:B;A:A;A20;B:B;">0");"") |
D22 | =WENN(A22="";SUMMEWENNS(B:B;A:A;A21;B:B;">0");"") |
C23 | =SUMME(B21:B22) |
D23 | =WENN(A23="";SUMMEWENNS(B:B;A:A;A22;B:B;">0");"") |
D24 | =WENN(A24="";SUMMEWENNS(B:B;A:A;A23;B:B;">0");"") |
D25 | =WENN(A25="";SUMMEWENNS(B:B;A:A;A24;B:B;">0");"") |
D26 | =WENN(A26="";SUMMEWENNS(B:B;A:A;A25;B:B;">0");"") |
D27 | =WENN(A27="";SUMMEWENNS(B:B;A:A;A26;B:B;">0");"") |
C28 | =SUMME(B24:B27) |
D28 | =WENN(A28="";SUMMEWENNS(B:B;A:A;A27;B:B;">0");"") |
D29 | =WENN(A29="";SUMMEWENNS(B:B;A:A;A28;B:B;">0");"") |
D30 | =WENN(A30="";SUMMEWENNS(B:B;A:A;A29;B:B;">0");"") |
D31 | =WENN(A31="";SUMMEWENNS(B:B;A:A;A30;B:B;">0");"") |
D32 | =WENN(A32="";SUMMEWENNS(B:B;A:A;A31;B:B;">0");"") |
D33 | =WENN(A33="";SUMMEWENNS(B:B;A:A;A32;B:B;">0");"") |
D34 | =WENN(A34="";SUMMEWENNS(B:B;A:A;A33;B:B;">0");"") |
C35 | =SUMME(B29:B34) |
D35 | =WENN(A35="";SUMMEWENNS(B:B;A:A;A34;B:B;">0");"") |
D36 | =WENN(A36="";SUMMEWENNS(B:B;A:A;A35;B:B;">0");"") |
D37 | =WENN(A37="";SUMMEWENNS(B:B;A:A;A36;B:B;">0");"") |
D38 | =WENN(A38="";SUMMEWENNS(B:B;A:A;A37;B:B;">0");"") |
D39 | =WENN(A39="";SUMMEWENNS(B:B;A:A;A38;B:B;">0");"") |
C40 | =SUMME(B36:B39) |
D40 | =WENN(A40="";SUMMEWENNS(B:B;A:A;A39;B:B;">0");"") |