抱歉,代码第10行 arr(i, 4) 应为 arr(j, 4),
现已更正。
- Sub YuBa()
- Dim arr, ar, y%, i%, j%
- [j4:j1000] = ""
- y = Range("j1").Value
- arr = Range("a2").CurrentRegion
- ar = Range("i4").CurrentRegion
- For i = 2 To UBound(ar)
- For j = 2 To UBound(arr)
- If Month(arr(j, 1)) = y And arr(j, 3) = ar(i, 1) Then
- ar(i, 2) = ar(i, 2) + arr(j, 4)
- End If
- Next
- Next
- [i3].Resize(i - 1, 2) = ar
- End Sub
复制代码
统计月数据.rar
(16.1 KB, 下载次数: 18)
|