Excel如何进行文字赋值并求和??问题可能没提好,目的是想解决下图中的...答:=RIGHT(A$1,LEN(A$1)-FIND("-",A$1))*A2+RIGHT(B$1,LEN(B$1)-FIND("-",B$1))*B2+RIGHT(D$1,LEN(D$1)-FIND("-",D$1))*D2+RIGHT(E$1,LEN(E$1)-FIND("-",E$1))*E2+RIGHT(G$1,LEN(G$1)-FIND("-",G$1))*G2+RIGHT(H$1,LEN(H$1)-FIND("-",H$1))...