re-bonsoir
macro qui met le résultat dans une nouvelle feuille
Sub aargh()
dl = Cells(Rows.Count, 1).End(xlUp).Row
ActiveSheet.Copy after:=Sheets(Sheets.Count)
Range("A1:D" & dl).Sort key1:=[A1], order1:=xlAscending, key2:=[B2], order2:=xlAscending, key3:=[C3], order3:=xlAscending, Header:=xlYes
For i = dl To 2 Step -1
If Cells(i, 1) = Cells(i - 1, 1) And Cells(i, 2) = Cells(i - 1, 2) And Cells(i, 3) = Cells(i - 1, 3) Then
Cells(i - 1, 4) = Cells(i - 1, 4) + Cells(i, 4)
Rows(i).Delete shift:=xlUp
End If
Next i
End Sub