| G | H | I | J | K | L | M | 5 | | Uwe | Achim | Lutz | Micha | Pamy | Danny | 6 | 101 | 2,41 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 7 | 102 | 0,00 | 2,88 | 0,00 | 0,00 | 0,00 | 0,00 | 8 | 103 | 0,00 | 0,00 | 2,24 | 0,00 | 0,00 | 0,00 | 9 | 104 | 0,00 | 0,00 | 0,00 | 3,02 | 0,00 | 0,00 | 10 | 105 | 0,00 | 0,00 | 0,00 | 0,00 | 3,55 | 0,00 | 11 | 106 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 4,15 | 12 | 107 | 0,00 | 0,00 | 4,15 | 0,00 | 0,00 | 0,00 | 13 | 108 | 0,00 | 0,00 | 0,00 | 0,00 | 4,76 | 0,00 | 14 | 109 | 0,00 | 2,94 | 0,00 | 0,00 | 0,00 | 0,00 | 15 | 110 | 0,00 | 0,00 | 3,55 | 0,00 | 0,00 | 0,00 | 16 | 111 | 0,00 | 0,00 | 0,00 | 0,00 | 4,15 | 0,00 | 17 | 112 | 0,00 | 0,00 | 4,76 | 0,00 | 0,00 | 0,00 | 18 | 113 | 0,00 | 0,00 | 0,00 | 0,00 | 2,41 | 0,00 | 19 | 114 | 0,00 | 2,88 | 0,00 | 0,00 | 0,00 | 0,00 | 20 | 115 | 0,00 | 0,00 | 2,24 | 0,00 | 0,00 | 0,00 | 21 | 116 | 0,00 | 0,00 | 0,00 | 0,00 | 3,02 | 0,00 | 22 | | 2,41 | 8,70 | 16,94 | 3,02 | 17,89 | 4,15 | Formeln der Tabelle | H6 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G6)*$C$5:$C$36)
I6 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G6)*$C$5:$C$36)
J6 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G6)*$C$5:$C$36)
K6 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G6)*$C$5:$C$36)
L6 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G6)*$C$5:$C$36)
M6 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G6)*$C$5:$C$36)
H7 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G7)*$C$5:$C$36)
I7 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G7)*$C$5:$C$36)
J7 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G7)*$C$5:$C$36)
K7 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G7)*$C$5:$C$36)
L7 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G7)*$C$5:$C$36)
M7 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G7)*$C$5:$C$36)
H8 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G8)*$C$5:$C$36)
I8 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G8)*$C$5:$C$36)
J8 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G8)*$C$5:$C$36)
K8 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G8)*$C$5:$C$36)
L8 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G8)*$C$5:$C$36)
M8 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G8)*$C$5:$C$36)
H9 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G9)*$C$5:$C$36)
I9 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G9)*$C$5:$C$36)
J9 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G9)*$C$5:$C$36)
K9 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G9)*$C$5:$C$36)
L9 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G9)*$C$5:$C$36)
M9 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G9)*$C$5:$C$36)
H10 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G10)*$C$5:$C$36)
I10 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G10)*$C$5:$C$36)
J10 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G10)*$C$5:$C$36)
K10 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G10)*$C$5:$C$36)
L10 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G10)*$C$5:$C$36)
M10 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G10)*$C$5:$C$36)
H11 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G11)*$C$5:$C$36)
I11 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G11)*$C$5:$C$36)
J11 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G11)*$C$5:$C$36)
K11 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G11)*$C$5:$C$36)
L11 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G11)*$C$5:$C$36)
M11 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G11)*$C$5:$C$36)
H12 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G12)*$C$5:$C$36)
I12 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G12)*$C$5:$C$36)
J12 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G12)*$C$5:$C$36)
K12 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G12)*$C$5:$C$36)
L12 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G12)*$C$5:$C$36)
M12 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G12)*$C$5:$C$36)
H13 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G13)*$C$5:$C$36)
I13 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G13)*$C$5:$C$36)
J13 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G13)*$C$5:$C$36)
K13 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G13)*$C$5:$C$36)
L13 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G13)*$C$5:$C$36)
M13 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G13)*$C$5:$C$36)
H14 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G14)*$C$5:$C$36)
I14 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G14)*$C$5:$C$36)
J14 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G14)*$C$5:$C$36)
K14 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G14)*$C$5:$C$36)
L14 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G14)*$C$5:$C$36)
M14 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G14)*$C$5:$C$36)
H15 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G15)*$C$5:$C$36)
I15 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G15)*$C$5:$C$36)
J15 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G15)*$C$5:$C$36)
K15 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G15)*$C$5:$C$36)
L15 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G15)*$C$5:$C$36)
M15 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G15)*$C$5:$C$36)
H16 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G16)*$C$5:$C$36)
I16 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G16)*$C$5:$C$36)
J16 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G16)*$C$5:$C$36)
K16 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G16)*$C$5:$C$36)
L16 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G16)*$C$5:$C$36)
M16 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G16)*$C$5:$C$36)
H17 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G17)*$C$5:$C$36)
I17 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G17)*$C$5:$C$36)
J17 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G17)*$C$5:$C$36)
K17 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G17)*$C$5:$C$36)
L17 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G17)*$C$5:$C$36)
M17 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G17)*$C$5:$C$36)
H18 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G18)*$C$5:$C$36)
I18 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G18)*$C$5:$C$36)
J18 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G18)*$C$5:$C$36)
K18 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G18)*$C$5:$C$36)
L18 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G18)*$C$5:$C$36)
M18 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G18)*$C$5:$C$36)
H19 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G19)*$C$5:$C$36)
I19 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G19)*$C$5:$C$36)
J19 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G19)*$C$5:$C$36)
K19 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G19)*$C$5:$C$36)
L19 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G19)*$C$5:$C$36)
M19 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G19)*$C$5:$C$36)
H20 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G20)*$C$5:$C$36)
I20 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G20)*$C$5:$C$36)
J20 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G20)*$C$5:$C$36)
K20 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G20)*$C$5:$C$36)
L20 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G20)*$C$5:$C$36)
M20 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G20)*$C$5:$C$36)
H21 : =SUMMENPRODUKT(($A$5:$A$36=H$5)*($B$5:$B$36=$G21)*$C$5:$C$36)
I21 : =SUMMENPRODUKT(($A$5:$A$36=I$5)*($B$5:$B$36=$G21)*$C$5:$C$36)
J21 : =SUMMENPRODUKT(($A$5:$A$36=J$5)*($B$5:$B$36=$G21)*$C$5:$C$36)
K21 : =SUMMENPRODUKT(($A$5:$A$36=K$5)*($B$5:$B$36=$G21)*$C$5:$C$36)
L21 : =SUMMENPRODUKT(($A$5:$A$36=L$5)*($B$5:$B$36=$G21)*$C$5:$C$36)
M21 : =SUMMENPRODUKT(($A$5:$A$36=M$5)*($B$5:$B$36=$G21)*$C$5:$C$36)
H22 : =SUMME(H6:H21)
I22 : =SUMME(I6:I21)
J22 : =SUMME(J6:J21)
K22 : =SUMME(K6:K21)
L22 : =SUMME(L6:L21)
M22 : =SUMME(M6:M21)
|
|