need excel formula

[kcbikeswim]

I need help with writing a formula. What I need is an auto sum formula that will total a line of cells with numbers that are both positive and negative numbers, but not adding and subtracting, only totaling the numbers.

Example,    5, 5, -10, 5.   the answer would be 25.

Thanks 

[#2 · Accepted solution]

@kcbikeswim 

=SUM(ABS(A1:A4))

[#3]

@kcbikeswim 

With everyone's permission, I would like to add this example to Mr.Detlef Lewin

very good suggestion.

Enclosed in the file.

Thx

[#4]

Thank you so much. Really appreciate the help

[#5]

@kcbikeswim 

For me the formula is 

= SUM(ABS(Value₁))

but, for anyone stuck with legacy versions of Excel, it is also possible to use a defined name for the array calculation.  The formula is then

= SUM(Absolut)

[without CSE] where 'Absolut' is defined to be

= ABS(Value₁)