加總 依數字與代號 (13669)

O2{=SUM(N(+C2:N2),COUNTIF(C2:N2,{"AL","CL"})*8,COUNTIF(C2:N2,"A/"&ROW($1:$9))*ROW($1:$9))

另解{=SUM(N(+C2:N2),COUNTIF(C2:N2,{"AL","CL"})*8,("A/"&RIGHT(C2:N2)=C2:N2)*IFERROR(RIGHT(C2:N2)*1,))