"Dave Peterson" wrote in message
...
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

I am somewhat puzzled! If I have 2000 random numbers both
positive and negative in column A, I can sum them with =SUM(A:A)
in say B2000.
=SUM(ABS(A:A)) in C2000 also works.

I am using Excel2000.



--
James Silverton
Potomac, Maryland