Zelle | Formel |
AL2 | {=SUMME(WENN($S2:$AI2="A";$T2:$AJ2))} |
AM2 | {=SUMME(WENN($S2:$AI2="Q";$T2:$AJ2))} |
AN2 | {=SUMME(WENN($S2:$AI2="P";$T2:$AJ2))} |
AO2 | {=SUMME(WENN($S2:$AI2="K";$T2:$AJ2))} |
AP2 | {=SUMME(WENN($S2:$AI2="U";$T2:$AJ2))} |
AQ2 | {=SUMME(WENN($S2:$AI2="B";$T2:$AJ2))} |
AR2 | {=SUMME(WENN($S2:$AI2="E";$T2:$AJ2))} |
AS2 | {=SUMME(WENN($S2:$AI2="F";$T2:$AJ2))} |
AT2 | {=SUMME(WENN($S2:$AI2="V";$T2:$AJ2))} |
AL3 | {=SUMME(WENN($S3:$AI3="A";$T3:$AJ3))} |
AM3 | {=SUMME(WENN($S3:$AI3="Q";$T3:$AJ3))} |
AN3 | {=SUMME(WENN($S3:$AI3="P";$T3:$AJ3))} |
AO3 | {=SUMME(WENN($S3:$AI3="K";$T3:$AJ3))} |
AP3 | {=SUMME(WENN($S3:$AI3="U";$T3:$AJ3))} |
AQ3 | {=SUMME(WENN($S3:$AI3="B";$T3:$AJ3))} |
AR3 | {=SUMME(WENN($S3:$AI3="E";$T3:$AJ3))} |
AS3 | {=SUMME(WENN($S3:$AI3="F";$T3:$AJ3))} |
AT3 | {=SUMME(WENN($S3:$AI3="V";$T3:$AJ3))} |
AL4 | {=SUMME(WENN($S4:$AI4="A";$T4:$AJ4))} |
AM4 | {=SUMME(WENN($S4:$AI4="Q";$T4:$AJ4))} |
AN4 | {=SUMME(WENN($S4:$AI4="P";$T4:$AJ4))} |
AO4 | {=SUMME(WENN($S4:$AI4="K";$T4:$AJ4))} |
AP4 | {=SUMME(WENN($S4:$AI4="U";$T4:$AJ4))} |
AQ4 | {=SUMME(WENN($S4:$AI4="B";$T4:$AJ4))} |
AR4 | {=SUMME(WENN($S4:$AI4="E";$T4:$AJ4))} |
AS4 | {=SUMME(WENN($S4:$AI4="F";$T4:$AJ4))} |
AT4 | {=SUMME(WENN($S4:$AI4="V";$T4:$AJ4))} |
AL5 | {=SUMME(WENN($S5:$AI5="A";$T5:$AJ5))} |
AM5 | {=SUMME(WENN($S5:$AI5="Q";$T5:$AJ5))} |
AN5 | {=SUMME(WENN($S5:$AI5="P";$T5:$AJ5))} |
AO5 | {=SUMME(WENN($S5:$AI5="K";$T5:$AJ5))} |
AP5 | {=SUMME(WENN($S5:$AI5="U";$T5:$AJ5))} |
AQ5 | {=SUMME(WENN($S5:$AI5="B";$T5:$AJ5))} |
AR5 | {=SUMME(WENN($S5:$AI5="E";$T5:$AJ5))} |
AS5 | {=SUMME(WENN($S5:$AI5="F";$T5:$AJ5))} |
AT5 | {=SUMME(WENN($S5:$AI5="V";$T5:$AJ5))} |
AL6 | {=SUMME(WENN($S6:$AI6="A";$T6:$AJ6))} |
AM6 | {=SUMME(WENN($S6:$AI6="Q";$T6:$AJ6))} |
AN6 | {=SUMME(WENN($S6:$AI6="P";$T6:$AJ6))} |
AO6 | {=SUMME(WENN($S6:$AI6="K";$T6:$AJ6))} |
AP6 | {=SUMME(WENN($S6:$AI6="U";$T6:$AJ6))} |
AQ6 | {=SUMME(WENN($S6:$AI6="B";$T6:$AJ6))} |
AR6 | {=SUMME(WENN($S6:$AI6="E";$T6:$AJ6))} |
AS6 | {=SUMME(WENN($S6:$AI6="F";$T6:$AJ6))} |
AT6 | {=SUMME(WENN($S6:$AI6="V";$T6:$AJ6))} |