|
非数值型数据均未计入统计对象:
Sub ave()
Dim ar()
With Sheets("8.1")
i1% = .[c65536].End(3).Row
If i1 < 3 Then Exit Sub
ar = .[c1].Resize(i1, 8).Value
End With
For i1 = 1 To 8
ar(1, i1) = 0
ar(2, i1) = 0
For i2% = 3 To UBound(ar)
If VarType(ar(i2, i1)) = 5 Then
ar(1, i1) = ar(1, i1) + 1
ar(2, i1) = ar(2, i1) + ar(i2, i1)
End If
Next
If ar(1, i1) Then ar(1, i1) = ar(2, i1) / ar(1, i1)
Next
Sheets("成绩分析").[b3:i3] = ar
End Sub |
|