Zelle | Formel |
J3 | =SUMMENPRODUKT((F$2:F$99="w")*(E$2:E$99<=6)) |
K3 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92<=6)) |
L3 | =J3+K3 |
M3 | =SUMMENPRODUKT((E$2:E$92<=6)*(G$2:G$92="X")) |
J4 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92>=7)*(E$2:E$92<=14)) |
K4 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92>=7)*(E$2:E$92<=14)) |
L4 | =J4+K4 |
M4 | =SUMMENPRODUKT((E$2:E$92>=7)*(E$2:E$92<=14)*(G$2:G$92="X")) |
J5 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92=15)) |
K5 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92=15)) |
L5 | =J5+K5 |
M5 | =SUMMENPRODUKT((E$2:E$92=15)*(G$2:G$92="X")) |
J6 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92>=16)*(E$2:E$92<=18)) |
K6 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92>=16)*(E$2:E$92<=18)) |
L6 | =J6+K6 |
M6 | =SUMMENPRODUKT((E$2:E$92>=16)*(E$2:E$92<=18)*(G$2:G$92="X")) |
J7 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92>=19)*(E$2:E$92<=26)) |
K7 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92>=19)*(E$2:E$92<=26)) |
L7 | =J7+K7 |
M7 | =SUMMENPRODUKT((E$2:E$92>=19)*(E$2:E$92<=26)*(G$2:G$92="X")) |
J8 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92>=27)*(E$2:E$92<=40)) |
K8 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92>=27)*(E$2:E$92<=40)) |
L8 | =J8+K8 |
M8 | =SUMMENPRODUKT((E$2:E$92>=27)*(E$2:E$92<=40)*(G$2:G$92="X")) |
J9 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92>=41)*(E$2:E$92<=60)) |
K9 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92>=41)*(E$2:E$92<=60)) |
L9 | =J9+K9 |
M9 | =SUMMENPRODUKT((E$2:E$92>=41)*(E$2:E$92<=60)*(G$2:G$92="X")) |
J10 | =SUMMENPRODUKT((F$2:F$92="w")*(E$2:E$92>60)) |
K10 | =SUMMENPRODUKT((F$2:F$92="m")*(E$2:E$92>60)) |
L10 | =J10+K10 |
M10 | =SUMMENPRODUKT((E$2:E$92>=60)*(G$2:G$92="X")) |
J11 | =SUMME(J3:J10) |
K11 | =SUMME(K3:K10) |
L11 | =SUMME(L3:L10) |
M11 | =SUMME(M3:M10) |