Sub Click()
Dim i, j, k
For i = 30 To 32
Cells(i, 6) = 0
For j = 3 To 10 Step 7
For k = 24 To 29
If Cells(i, 3) = Cells(k, j) Then Cells(i, 6) = Cells(i, 6) + Cells(k, j + 5)
Next k
Next j
Next i
End Sub
Sub Click()
Dim i, j, k
For i = 30 To 32
Cells(i, 6) = 0
For j = 3 To 10 Step 7
For k = 24 To 29
If Cells(i, 3) = Cells(k, j) Then Cells(i, 6) = Cells(i, 6) + Cells(k, j + 5)
Next k
Next j
Next i
End Sub