" 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

ABS(A1) returns the non-negative value of A1. For example, both ABS(-1) and
ABS(1) are 1. So you could write:

=abs(A1)+abs(B2)+abs(C3)


----- original message -----

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