N2:N12=AND(MMULT(1-ISERR(FIND("A",T(OFFSET(B2,,ROW($1:$4)*3-4+COLUMN(A:C))))),{1;1;1})>0)*(COUNTIF(B2:M2,"D")=0)
B13=SUM(N:N)
無輔助=SUM(((MMULT(N(LEFT(B2:D12)="A"),{1;1;1})>0)+(MMULT(N(LEFT(E2:G12)="A"),{1;1;1})>0)+(MMULT(N(LEFT(H2:J12)="A"),{1;1;1})>0)+(MMULT(N(LEFT(K2:M12)="A"),{1;1;1})>0)=4)*(MMULT(N(B2:M12="D"),ROW(1:12)^0)=0))
留言
張貼留言