|
本帖最后由 laoau138 于 2017-4-15 21:30 编辑
用VBA如何计算多个表金额
在sheet4内运行代码
- Sub aaa()
- Dim sh&, i&, arr, a$, b$, n&
- a = [a1]: b = [b1]
- For sh = 1 To 3
- arr = Sheets(sh).[a1].CurrentRegion
- For i = 1 To UBound(arr)
- If arr(i, 1) = a And arr(i, 2) = b Then n = n + arr(i, 3)
- Next i
- Next sh
- [c1] = n
- End Sub
复制代码
|
|