Option Explicit
Sub Essai()
If ActiveSheet.Name <> "FEUIL2" Then Exit Sub
Dim dlg&: dlg = Cells(Rows.Count, 3).End(3).Row: If dlg < 4 Then Exit Sub
Dim N(1 To 18) As Byte, lig&, c1 As Byte, c2 As Byte, v As Byte, k As Byte
Application.ScreenUpdating = 0: [P4:W21].ClearContents
For c1 = 4 To 11
Erase N
For lig = 4 To dlg
With Cells(lig, c1)
If .Interior.ColorIndex = -4142 Then
v = Val(.Value): If v >= 1 And v <= 18 Then N(v) = N(v) + 1
End If
End With
Next lig
For k = 1 To 18
lig = k + 3: c2 = c1 + 12: If N(k) > 0 Then Cells(lig, c2) = N(k)
Next k
Next c1
End Sub