Bonjour,
Ta macro modifiée :
Sub compteur()
Dim iR%, iC%, iRS%, iCS%, cpt%, ArrS, ArrC
ArrS = Worksheets("Ecart").Range("A1").CurrentRegion.Value
Range("B2:F300").ClearContents
ArrC = Range("A1").CurrentRegion.Value
For iRS = 2 To UBound(ArrS)
For iR = 2 To UBound(ArrC)
For iC = 4 To 6
For iCS = 6 To UBound(ArrS, 2)
If ArrS(iRS, 3) = ArrC(iR, 1) Then
Cells(iR, 2) = ArrS(iRS, 4)
Cells(iR, 3) = ArrS(iRS, 5)
If Not IsEmpty(ArrS(iRS, iCS)) Then
If ArrC(1, iC) = ArrS(iRS, iCS) Then
cpt = cpt + 1
End If
End If
End If
If cpt > 0 Then Cells(iR, iC) = cpt
Next
cpt = 0
Next
Next
Next
End Sub
A+