|
如附件- Function sumpro(rg1 As Range, rg2 As Range)
- Dim arr1, arr2, x%, n%, m%
- arr1 = rg1
- arr2 = rg2
- If UBound(arr1) * UBound(arr1, 2) = UBound(arr1) + UBound(arr1, 2) - 1 Then
- If UBound(arr1) = UBound(arr2) And UBound(arr1, 2) = UBound(arr2, 2) Then
- For n = 1 To UBound(arr1)
- For m = 1 To UBound(arr1, 2)
- If TypeName(arr1(n, m)) = "String" Then
- If arr1(n, m) = "/" Then
- arr1(n, m) = 0
- Else
- arr1(n, m) = 1
- End If
- End If
- If TypeName(arr2(n, m)) = "String" Then
- If arr2(n, m) = "/" Then
- arr2(n, m) = 0
- Else
- arr2(n, m) = 1
- End If
- End If
- x = x + arr1(n, m) * arr2(n, m)
- Next
- Next
- sumpro = x
- Else
- MsgBox "两参数不符合公式要求"
- End If
- Else
- MsgBox "两参数不符合公式要求"
- End If
- End Function
复制代码 |
|