Return + value instead of -
 

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
--
Therese

Return + value instead of -
 

Try:

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

HTH
JG

"Therese" wrote:

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
--
Therese

Return + value instead of -
 

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
--
Greetings from New Zealand
Bill K
"Therese" wrote in message
...
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
--
Therese

Return + value instead of -
 

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


"Bill Kuunders" skrev:

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
--
Greetings from New Zealand
Bill K
"Therese" wrote in message
...
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
--
Therese