Try...

=SUMPRODUCT(ABS(A1:A100))

Hope this helps!

In article ,
JON wrote:

LOOKING FOR A FORMULA THAT WILL ADD NUMBERS IN A COLUMN, REGARDLESS OF THEIR
SIGN. I DO NOT WANT NEGATIVE NUMBERS TO BE SUBTRACTED.