Sub test()
With Sheets(1)
rec = .Range("C65536").End(xlUp).Row
For i = 2 To rec
bb = .Cells(i, 2)
dd = .Cells(i, 4)
'MsgBox (dd = "A")
Select Case bb
Case "0"
Select Case dd
Case "A"
a1 = a1 + 1
Case "B"
b1 = b1 + 1
Case "C"
c1 = c1 + 1
Case "D"
d1 = d1 + 1
Case "E"
e1 = e1 + 1
Case "F"
f1 = f1 + 1
Case "G"
g1 = g1 + 1
End Select
Case "1"
Select Case dd
Case "A"
a2 = a2 + 1
Case "B"
b2 = b2 + 1
Case "C"
c2 = c2 + 1
Case "D"
d2 = d2 + 1
Case "E"
e2 = e2 + 1
Case "F"
f2 = f2 + 1
Case "G"
g2 = g2 + 1
End Select
End Select
Next
End With
End Sub