Sub testb_bis()
Dim i As Byte, j As Byte, X As Integer
X = 0
Z = 16
For i = 2 To 6
For j = 2 To 6
If Sheets("page1").Cells(j, i).Value = Range("A1") Then
X = X + 1
Cells(11, Z).Value = X
Else: Cells(11, Z).Value = "0"
End If
Next j
Z = Z + 1
Next i
End Sub