Forum Discussion
Solved
need excel formula
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
=SUM(ABS(A1:A4))
4 Replies
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₁)
With everyone's permission, I would like to add this example to Mr.Detlef Lewin
very good suggestion.Enclosed in the file.Thx=SUM(ABS(A1:A4))- Thank you so much. Really appreciate the help
