Sub Calcule()
[K3:V23].Interior.Color = xlNone
[M3:M23].ClearContents: [P3:P23].ClearContents: [S3:S23].ClearContents: [V3:V23].ClearContents
For C = 3 To 9 Step 2
For L = 3 To 23
If Cells(L, C) = "" Then Début = L
For L2 = L + 1 To 23
If Cells(L2, C) = "" Then
Fin = L2
Cells(L2, 1.5 * C + 8.5) = Application.Sum(Range(Cells(Début, C - 1), Cells(Fin - 1, C - 1)))
Cells(L2, 1.5 * C + 8.5).Interior.Color = Cells(L2, C).Interior.Color
L = L2 - 1
Exit For
End If
Next L2
Next L
Next C
End Sub