- Sub 统计()
- Dim Arr1, Arr2()
- Arr1 = Sheets("sheet1").Range("g4:K20")
- ReDim Arr2(1 To UBound(Arr1), 1 To 2)
- For i = 1 To UBound(Arr1)
- If IsEmpty(Cells(i + 3, "n")) And Arr1(i, 1) + Arr1(i, 2) + Arr1(i, 3) + Arr1(i, 4) + Arr1(i, 5) <> 0 Then
- Arr2(i, 1) = Arr1(i, 1) + Arr1(i, 2) + Arr1(i, 3) + Arr1(i, 4) + Arr1(i, 5)
- For k = 1 To UBound(Arr1)
- If Arr1(k, 1) + Arr1(k, 2) + Arr1(k, 3) + Arr1(k, 4) + Arr1(k, 5) > Arr2(i, 1) _
- And Cells(k + 3, "n") = "" _
- And Arr1(i, 1) + Arr1(i, 2) + Arr1(i, 3) + Arr1(i, 4) + Arr1(i, 5) <> 0 Then
- r = r + 1
- End If
- Next k
- Arr2(i, 2) = r + 1
- r = 0
- End If
- Next i
- Sheets("sheet1").Range("v4").Resize(UBound(Arr1), 2).ClearContents
- Sheets("sheet1").Range("v4").Resize(UBound(Arr1), 2) = Arr2
- End Sub
复制代码 |