Sub TotalisationCouleur1()
Dim Aselectionner As Range, Cel As Range, som
Application.DisplayAlerts = False
On Error Resume Next
Set Aselectionner = Application.InputBox(prompt:="selectionner la plage de cellule ", Title:=" Plage de cellules à sélectioner", Type:=8)
If Err Then Exit Sub
On Error GoTo 0
For Each Cel In Aselectionner
If IsNumeric(Cel) Then If Cel.Interior.Color = RGB(255, 255, 255) Then som = som + Cel
Next Cel
MsgBox som
End Sub