|
发表于 2012-1-13 10:39
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-13 10:42 编辑
如果你是想用VBA完成累加用下面代码就行了
- Sub leijia()
- Dim arr, arr1, i As Long, j As Long
- Range(Cells(3, 7), Cells([G65536].End(xlUp).Row, 11)).ClearContents
- arr = Range(Cells(3, 1), Cells([A65536].End(xlUp).Row, 6))
- ReDim arr1(1 To UBound(arr), 1 To 5)
- For i = 1 To UBound(arr)
- For j = 1 To 5
- If i = 1 Then
- arr1(i, j) = arr(i, j + 1)
- Else
- arr1(i, j) = arr(i, j + 1) + arr1(i - 1, j)
- End If
- Next j
- Next i
- Range("G3").Resize(UBound(arr1), 5) = arr1
- End Sub
复制代码 附件:
根据条件汇总求和和累计-sunjing.rar
(33.04 KB, 下载次数: 26)
|
|