|
- Sub 统计()
- Dim x As Range
- For i = 3 To [b65536].End(3).Row
- Cells(i, "L") = Cells(i, 2) - Application.WorksheetFunction.Count(Cells(i, 3).Resize(1, 9))
- For Each x In Cells(i, 3).Resize(1, 9)
- If Len(x) > 0 And x.Interior.ColorIndex = 3 Then Cells(i, "L") = Cells(i, "L") + 0.5
- Next
- Next
- End Sub
复制代码 |
|