|
本帖最后由 Excel学徒123 于 2017-4-13 17:26 编辑
可以啊, '自定义函数,rg选择A2单元格,即要拆分的单元格,rng选择要引用的区域即可,具体看图
- '自定义函数,rg选择A2单元格,即要拆分的单元格,rng选择要引用的区域即可
- Function Sumx(rg As Range, rng As Range) As Double
- Dim arr, arrSrc
- Dim irow%, irow_1%
- Dim temSum#
- arr = Split(Replace(rg, ",", ","), ",")
- arrSrc = rng.Value
- For irow = 0 To UBound(arr)
- For irow_1 = 1 To UBound(arrSrc)
- If arr(irow) * 1 = arrSrc(irow_1, 1) Then
- temSum = temSum + arrSrc(irow_1, 2)
- End If
- Next
- Next
- Sumx = temSum
- End Function
复制代码
|
|