Sub SousTot()
Dim Zone
Set Zone = [A7].CurrentRegion
Zone.Select
Selection.RemoveSubtotal
Selection.Sort Key1:=Range("B8"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Selection.Subtotal GroupBy:=2, Function:=xlSum, _
TotalList:=Array(11, 12, 13, 14, 15, 16, 17, 18), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
End Sub