Option Explicit
Sub Essai()
Dim dlg&: dlg = Cells(Rows.Count, 2).End(3).Row: If dlg < 3 Then Exit Sub
Dim Tbl, T(5), lig&, col%: dlg = dlg - 2: Tbl = [B3].Resize(dlg, 17)
For lig = 1 To dlg
If Tbl(lig, 1) <> "" Then
T(0) = 0
For col = 3 To 7
T(0) = T(0) + Tbl(lig, col)
T(col - 2) = T(col - 2) + Tbl(lig, col)
Next col
Tbl(lig, 17) = T(0)
End If
Next lig
Application.ScreenUpdating = 0: Columns(18).ClearContents
For col = 4 To 8
Cells(2, col) = T(col - 3)
Next col
[R3].Resize(dlg) = Application.Index(Tbl, Evaluate("Row(" & "1:" & dlg & ")"), 17)
End Sub