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 t...
=SUM(ABS(A1:A4))
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₁)