ruking512 发表于 2015-4-6 17:42
谢谢你的热心帮忙。
可能我没讲清楚,我只要F3列*号后面的数字 。就是说我只要“*”号与“件”中间的数字 ...
这样的话,就不需用宏表了
但是公式很长
J3=IF(LEN(F3),SUM(IF(ISNUMBER(FIND("件",TRIM(MID(SUBSTITUTE(SUBSTITUTE(F3,"*","+"),"+",REPT(" ",99)),ROW(INDIRECT("1:"&1+LEN(F3)-LEN(SUBSTITUTE(SUBSTITUTE(F3,"*","+"),"+",""))))*99-98,99)))),--SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(F3,"*","+"),"+",REPT(" ",99)),ROW(INDIRECT("1:"&1+LEN(F3)-LEN(SUBSTITUTE(SUBSTITUTE(F3,"*","+"),"+",""))))*99-98,99)),"件",""),))*I3,I2)三键结束,下拉
修正.rar
(128.61 KB, 下载次数: 2)