i had a cell (C1) called "total" that displays the sum of two other cells..
i.e. the total cell got the formula "=sum(A1+B1)" ..

I then typed a value in cell (D1). Then I tried to add C1 to D1 in the cell
E1. I used segma sign to add the two cells(C1+D1)
or I typed the formula "=sum(C1+D1)" in the cell E1. However, the cell E1
gave a "Value!" error.

I don't know why..

when I tried the same in another computer, it worked well

I wonder if there is options to make the cell E1 show the result.

Is there any reason you are using

=SUM(C1+D1)

and not

=SUM(C1:D1)

?

Regardless the value error happens because you use an operand ( + in this
case) and at least one of the values are text, if you use the latter formula
you won't get an error since sum ignores text but you won't get the correct
result either

Make sure both values are number by making sure both cells are formatted as
general or number and typing in the values to test.

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"r" wrote in message
...
i had a cell (C1) called "total" that displays the sum of two other cells..
i.e. the total cell got the formula "=sum(A1+B1)" ..

I then typed a value in cell (D1). Then I tried to add C1 to D1 in the
cell
E1. I used segma sign to add the two cells(C1+D1)
or I typed the formula "=sum(C1+D1)" in the cell E1. However, the cell E1
gave a "Value!" error.

I don't know why..

when I tried the same in another computer, it worked well

I wonder if there is options to make the cell E1 show the result.

sorry. That was a typo in the messege. I ment to type "=sum(C1:D1)"

Any way, you are right.. I have to make both cells formatted as general or
number.
That was the problem.

Thank you

"Peo Sjoblom" wrote:

Is there any reason you are using

=SUM(C1+D1)

and not

=SUM(C1:D1)

?

Regardless the value error happens because you use an operand ( + in this
case) and at least one of the values are text, if you use the latter formula
you won't get an error since sum ignores text but you won't get the correct
result either

Make sure both values are number by making sure both cells are formatted as
general or number and typing in the values to test.

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"r" wrote in message
...
i had a cell (C1) called "total" that displays the sum of two other cells..
i.e. the total cell got the formula "=sum(A1+B1)" ..

I then typed a value in cell (D1). Then I tried to add C1 to D1 in the
cell
E1. I used segma sign to add the two cells(C1+D1)
or I typed the formula "=sum(C1+D1)" in the cell E1. However, the cell E1
gave a "Value!" error.

I don't know why..

when I tried the same in another computer, it worked well

I wonder if there is options to make the cell E1 show the result.