Function SommaCol(rng As Range) Dim cel As Range For Each cel In rng If cel.Interior.ColorIndex = 44 Then SommaCol = SommaCol + cel.Value End If Next cel End Function