Function chr(a As String)
b = Split(a, " ")
For i = 0 To UBound(b)
c = Split(b(i), "-")
chr = chr * 1 + c(1) * 1
Next
End Function
我帮二楼的完善下，过滤类似TOTAL100这样不含“-”字段
Function chr(a As String)
b = Split(a, " ")
For i = 0 To UBound(b)
If InStr(b(i), "-") Then
c = Split(b(i), "-")
chr = chr * 1 + c(1) * 1
End If
Next
End Function
B1:
=SUM(IFERROR(--FILTERXML(""&SUBSTITUTE(SUBSTITUTE(A1,"pcs","Total"),"Total","")&"","//b"),))
ctrl+shift+回车，下拉
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024