If you're only adding 2 values together, then there's really no point in
using the SUM function.

In cell C1 enter:

=A1+B1

In cell E1 enter:

=C1+D1

HTH,
Elkar


"r" wrote:

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