|
本帖最后由 microyip 于 2017-11-8 23:45 编辑
- Sub 统计()
- Dim vData As Variant, nRow As Integer, nCol As Integer
- Dim vFill As Variant
-
- ReDim vFill(1 To 10)
- vData = Sheet1.[A1].CurrentRegion.Value
- vFill(1) = DateValue(Split(Split(vData(1, 1), ":")(1), ",")(0))
- For nRow = 3 To UBound(vData) - 1
- vFill(2) = vFill(2) - (vData(nRow, 5) > 0) * 1
- vFill(3) = vFill(3) + (vData(nRow, 4) > 0) * (vData(nRow, 5) = 0) * 1
- vFill(4) = vFill(4) - (vData(nRow, 4) = "") * 1
- If (vData(nRow, 7) <> "") Or (vData(nRow, 8) <> "") Then
- nCol = 5 - (vData(nRow, 7) <> "") * vData(nRow, 7) - (vData(nRow, 8) <> "") * (vData(nRow, 8) + 3)
- vFill(nCol) = vFill(nCol) + 1
- End If
- Next
- [J23:S23] = vFill
- [J23].NumberFormatLocal = "yyyy/m/d"
- End Sub
复制代码
|
|