=SUM(ABS(E1:E10))

entered with ctrl + shift & enter

or

=SUMPRODUCT(ABS(E1:E10))

entered normally


--


Regards,


Peo Sjoblom


"Viviank" wrote in message
...
How do I tell excel to add a column of numbers without regard to +/- sign.
I
want to know the gross total of all adjustments, not the net. Here's the
scenario. A house sells for $200,000, we make adjustments for
differences,
say -$1,000 here, +3,000 there, I want excel to tell me that I've made
$4000
in adjustments - not +2000. Thanks for your help.

Vivian