need excel formula

Copper Contributor

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.


4 Replies
best response confirmed by allyreckerman (Microsoft)




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

Thank you so much. Really appreciate the help


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₁)