Option Explicit
Sub TEST6()
Dim ar, br, i&, j&
Application.ScreenUpdating = False
ar = Range("E3", Cells(Rows.Count, "L").End(xlUp)).Value
ReDim br(1 To UBound(ar) - 1, 1 To 2)
br(1, 1) = "单位": br(1, 2) = "个人"
For i = 3 To UBound(ar)
For j = 1 To UBound(ar, 2)
If ar(1, j) = "单位" Then
br(i - 1, 1) = br(i - 1, 1) + ar(i, j)
Else
br(i - 1, 2) = br(i - 1, 2) + ar(i, j)
End If
Next j
Next i
Columns("Q:R").ClearContents
[Q4].Resize(UBound(br), UBound(br, 2)) = br
Application.ScreenUpdating = True
Beep
End Sub
|