首先说明,gdpgdp317 说的对,用数据透视表最快最好。
下面是我写的,我也是菜鸟
Sub qiuHe()
Dim arr, arr2(1 To 4)
arr = Range("A2:F" & Range("A65536").End(xlUp).Row)
arr2(1) = arr(1, 1)
arr2(2) = arr(1, 2)
arr2(4) = arr(1, 6)
arr2(3) = arr(1, 5)
For x = 2 To UBound(arr)
If arr(x, 6) = arr(x - 1, 6) And arr(x, 1) = arr(x - 1, 1) And arr(x, 2) = arr(x - 1, 2) Then
arr2(3) = arr2(3) + arr(x, 5)
Else
Cells(Range("J65536").End(xlUp).Row + 1, 10).Resize(1, 4) = arr2
arr2(1) = arr(x, 1)
arr2(2) = arr(x, 2)
arr2(4) = arr(x, 6)
arr2(3) = arr(x, 5)
End If
Next
Cells(Range("J65536").End(xlUp).Row + 1, 10).Resize(1, 4) = arr2
End Sub