數字均相同 總和 (14867)

F2=SUMPRODUCT((MMULT(1-ISERR(0/(FIND(MID(E2,COLUMN(A:I),1),"A"&B$2:B$7)>1)),ROW(1:9)^0)=LEN(E2))*(LEN(B$2:B$7)=LEN(E2))*C$2:C$7)