|
每个市分别下辖直管和非直管的县,除对各个直管县和非直管县向下求和之外,还需要对每个市求和。需要求和的数据为多列。
附件已经更新,请爱老师再次不吝赐教!
- Sub 按钮62_Click()
- Dim A, i%, j%, k%, x&, s&
- With Sheets("sheet1")
- A = .Range("a1:f" & .Range("a65536").End(xlUp).Row)
-
- For j = 2 To UBound(A, 2)
- For i = UBound(A) To 2 Step -1
-
- If InStr(A(i, 1), "小计") Then
- k = k + 1
- Select Case k
- Case 1 '其它
- A(i, j) = s: x = x + s: s = 0
- Case 2 '直管
- A(i, j) = s: x = x + s: s = 0
- Case 3 '市
- A(i, j) = x: x = 0: k = 0
- End Select
- Else
- s = s + A(i, j)
- End If
- Next i
-
- Next j
- .Range("a1").Resize(UBound(A), UBound(A, 2)) = A
- End With
- End Sub
复制代码
Book3c.rar
(12.14 KB, 下载次数: 19)
|
|