Sub test_Somme_ABS()
'à adapter au niveau de la variable Lig selon usage
Dim Lig&
Lig = 1
MsgBox Application.SumIf(Rows(Lig), ">0") - Application.SumIf(Rows(Lig), "<0")
End Sub
Sub Macro1()
For i = 2 To Range("A65535").End(xlUp).Row
dercol = Range("IV" & i).End(xlToLeft).Column
For j = 1 To dercol
y = y + Abs(Cells(i, j))
Cells(i, dercol + 1) = y
Next j
y = 0
Next i
End Sub