Sub 按钮1_Click()
Dim A, str1, str2, i, x, y
str1 = "成功": str2 = "失败"
A = Range("b1:b" & Range("b65536").End(xlUp).Row)
For i = 1 To UBound(A)
If A(i, 1) = str1 Then x = x + 1
If A(i, 1) = str2 Then y = y + 1
Next i
[e2] = x: [f2] = y
End Sub 求助用vba条件统计2.rar(16.19 KB, 下载次数: 13)
Sub 按钮1_Click()
Dim A, str1, str2, i, x, y
str1 = "成功": str2 = "失败"
A = Range("b1:b" & Range("b65536").End(xlUp).Row)
For i = 1 To UBound(A)
If A(i, 1) = str1 Then x = x + 1
If A(i, 1) = str2 Then y = y + 1
Next i
[e2] = x: [f2] = y
End Sub 求助用vba条件统计2.rar(16.19 KB, 下载次数: 13)