You can't change the value in a cell using a formula.

But you can sum the absolute values of a range:
=SUMPRODUCT(ABS(A1:A10))
Adjust the range to match, but you can't use the whole column until xl2007.


pcj101 wrote:

How do I change the cells in a column to absolute values then add them up in
one formula or function?

--

Dave Peterson