|
本帖最后由 hahada 于 2013-5-22 23:35 编辑
Sub 统计()
row1 = [A65536].End(xlUp).Row
For i = 5 To row1
If Cells(i, 3) = "aa" Or Cells(i, 3) = "bb" Or Cells(i, 3) = "dd" Then
cs = cs + 1
hj = hj + Cells(i, 2)
End If
Next i
[a2] = cs
[b2] = hj
End Sub
hahada 发表于 2013-5-22 23:29
求和数据结果向左移动3位
Sub 统计()
row1 = [A65536].End(xlUp).Row
For i = 5 To row1
If Cells(i, 3) = "aa" Or Cells(i, 3) = "bb" Or Cells(i, 3) = "dd" Then
cs = cs + 1
hj = hj + Cells(i, 2)
End If
Next i
[a2] = cs
[b2] = hj /1000
End Sub
|
|