With your values in A1 thru A3, enter:

=SUM(ABS(A1:A3))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
--
Gary''s Student - gsnu200851


" wrote:

I want to add negitive and possitive numbers, but I only want the total of
the value in the three columns ignoring the + or - sign. example (-2) (-3)
(4) would equal -1, but I want it to equal 9