Function mySum(rng As Range) As Double
Dim matchs As Object, match As Object
Dim k As Integer
Dim str As String
k = 1
str = rng.Text
'1)求倍数
If str Like "*套*" Then k = k * 2
If str Like "*对称各*" Then k = k * 2
'2)将所有的数相加
With CreateObject("VBScript.RegExp")
.Global = True
.Pattern = "\d
*\.?\d+"
Set matchs = .Execute(str)
For Each match In matchs
mySum = mySum + Val(match)
Next
End With
'3)输出
mySum = mySum * k
End Function
带特定字符的单元格求和3.rar
(15.11 KB, 下载次数: 8)