Return + value instead of -

[Guest]

In column A and B I have numbers that are summed in column C. Now some of the
numbers come out negative(as the result really is). I want to sum the numbers
in column C at the buttom, but the numbers not being negative( - in this
context it is indifferent whether they are positive or negative). I think I
read inhere something about a formula that will change the outcome, so that
all the numbers can be positive. Does anyone know that formula, or know how
to make them all positive?
Thanks a lot

 

[Guest]

Try:

=SUM(ABS(C1:C100))
entered using Shift+Ctrl+Enter

HTH
JG

 

[Bill Kuunders]

just to keep trach of the numbers you may want to use a help column
in column D with the formula =abs(c1) and extend that down.
then sum column D

 

[Guest]

Hey thanks for answer. Still haven't had time to see if it works. But thanks