Untitled

unknown
plain_text
4 days ago
8.1 kB
Indexable
Never
=SUM(IF(D2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(D3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(D4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(D5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(D6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(D7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(D8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(D9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(D10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(D11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(D12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(D13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(D14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(D15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(D16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(D17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(D18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(D19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(D20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(D21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(E2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(E3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(E4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(E5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(E6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(E7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(E8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(E9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(E10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(E11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(E12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(E13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(E14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(E15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(E16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(E17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(E18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(E19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(E20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(E21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(F2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(F3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(F4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(F5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(F6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(F7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(F8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(F9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(F10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(F11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(F12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(F13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(F14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(F15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(F16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(F17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(F18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(F19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(F20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(F21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(G2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(G3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(G4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(G5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(G6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(G7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(G8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(G9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(G10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(G11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(G12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(G13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(G14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(G15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(G16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(G17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(G18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(G19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(G20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(G21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(H2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(H3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(H4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(H5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(H6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(H7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(H8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(H9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(H10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(H11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(H12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(H13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(H14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(H15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(H16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(H17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(H18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(H19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(H20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(H21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(I2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(I3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(I4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(I5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(I6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(I7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(I8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(I9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(I10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(I11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(I12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(I13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(I14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(I15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(I16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(I17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(I18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(I19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(I20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(I21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(J2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(J3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(J4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(J5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(J6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(J7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(J8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(J9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(J10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(J11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(J12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(J13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(J14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(J15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(J16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(J17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(J18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(J19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(J20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(J21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(K2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(K3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(K4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(K5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(K6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(K7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(K8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(K9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(K10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(K11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(K12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(K13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(K14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(K15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(K16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(K17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(K18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(K19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(K20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(K21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))
=SUM(IF(L2=TRUE();C2/COUNTIF(D2:L2; TRUE());0);IF(L3=TRUE();C3/COUNTIF(D3:L3; TRUE());0);IF(L4=TRUE();C4/COUNTIF(D4:L4; TRUE());0);IF(L5=TRUE();C5/COUNTIF(D5:L5; TRUE());0);IF(L6=TRUE();C6/COUNTIF(D6:L6; TRUE());0);IF(L7=TRUE();C7/COUNTIF(D7:L7; TRUE());0);IF(L8=TRUE();C8/COUNTIF(D8:L8; TRUE());0);IF(L9=TRUE();C9/COUNTIF(D9:L9; TRUE());0);IF(L10=TRUE();C10/COUNTIF(D10:L10; TRUE());0);IF(L11=TRUE();C11/COUNTIF(D11:L11; TRUE());0);IF(L12=TRUE();C12/COUNTIF(D12:L12; TRUE());0);IF(L13=TRUE();C13/COUNTIF(D13:L13; TRUE());0);IF(L14=TRUE();C14/COUNTIF(D14:L14; TRUE());0);IF(L15=TRUE();C15/COUNTIF(D15:L15; TRUE());0);IF(L16=TRUE();C16/COUNTIF(D16:L16; TRUE());0);IF(L17=TRUE();C17/COUNTIF(D17:L17; TRUE());0);IF(L18=TRUE();C18/COUNTIF(D18:L18; TRUE());0);IF(L19=TRUE();C19/COUNTIF(D19:L19; TRUE());0);IF(L20=TRUE();C20/COUNTIF(D20:L20; TRUE());0);IF(L21=TRUE();C21/COUNTIF(D21:L21; TRUE());0))