如图所示,就是一个格子里面的数字,全部自动相加求和。求大神相助
Function chr(a As String)b = Split(a, " ")For i = 0 To UBound(b) c = Split(b(i), "-") chr = chr * 1 + c(1) * 1NextEnd Function
B1:
=SUM(IFERROR(--FILTERXML("<a><b>"&SUBSTITUTE(SUBSTITUTE(A1,"pcs","Total"),"Total","</b><b>")&"</b></a>","//b"),))
ctrl+shift+回车,下拉