Absolute values of a sum of cells

[Guest]

What formula do I use to get the absolute value of the sum of series of
cells. For example, if A2 through A9 has either a positive or negative
numbers in each one of the cells, I am trying to get the absolute value of
the sum.

 

[BenjieLop]

This is what you need

=ABS(SUM(A2:A9)

What formula do I use to get the absolute value of the sum of series of
cells. For example, if A2 through A9 has either a positive o
negative
numbers in each one of the cells, I am trying to get the absolute valu
of
the sum