Public Function couleurcara(plage As Range, cellule As Range)
Dim c As Range
Dim somme As Double
Application.Volatile
For Each c In plage
If c.Font.ColorIndex = cellule.Font.ColorIndex Then
somme = somme + c.Value
End If
Next c
couleurcara = somme
End Function