|
Sub 计算()
With ActiveSheet
r = .Cells(Rows.Count, 2).End(xlUp).Row
If r < 4 Then MsgBox "数据源为空": End
.Range("cu4:cx" & r) = Empty
.Range("f" & r & ":cx" & r) = Empty
ar = .Range("a3:cx" & r)
For i = 2 To UBound(ar)
hj1 = 0: hj = 0: hj = 0
If Trim(ar(i, 3)) <> "" Then
For j = 6 To UBound(ar, 2) - 4 Step 3
hj1 = hj1 + ar(i, j)
hj2 = hj2 + ar(i, j + 1)
hj3 = hj3 + ar(i, j + 2)
Next j
ar(i, UBound(ar, 2) - 3) = hj1
ar(i, UBound(ar, 2) - 2) = hj2
ar(i, UBound(ar, 2) - 1) = hj3
ar(i, UBound(ar, 2)) = ar(i, 5) + ar(i, UBound(ar, 2) - 3) - ar(i, UBound(ar, 2) - 2)
For j = 6 To UBound(ar, 2) Step 1
ar(UBound(ar), j) = ar(UBound(ar), j) + ar(i, j)
Next j
End If
Next i
.Range("a3:cx" & r) = ar
End With
MsgBox "ok!"
End Sub
|
|