Re,
Sub test()
celldeb = Split(Selection.Address, ":")(0)
cellfin = Split(Selection.Address, ":")(1)
coldeb = Split(celldeb, "$")(1)
colfin = Split(cellfin, "$")(1)
linedeb = Split(celldeb, "$")(2)
linefin = Split(cellfin, "$")(2)
Cells(linefin + 1, coldeb) = Application.WorksheetFunction.Sum(Range(coldeb & linedeb).value) * 12
Cells(linefin + 1, colfin) = Application.WorksheetFunction.SumProduct(Range(coldeb & linedeb + 1 & ":" & coldeb & linefin), Range(colfin & linedeb + 1 & ":" & colfin & linefin)) * 0.07 / 12
Cells(linefin + 1, colfin) = Cells(linefin + 1, colfin) + Range(colfin & linedeb).value * 0.07 / 12
End Sub