Sub fx()<br/>Dim a, c, n%, m%<br/>a = ActiveSheet.UsedRange<br/>For Each c In a<br/>If Val(Left(c, 1)) = 6 Then n = n + 1<br/>If Val(Left(c, 1)) = 7 Then m = m + 1<br/>Next<br/>MsgBox "6:" & n & "个" & vbCrLf & _<br/> "7:" & m & "个"<br/>End Sub<br/>