I copy a formula and the results copy from the original cell

[Guest]

I created a simple formula in a cell (D4+E4) and the result is, for example,
100. When I copy the formula into the line below the formula changes to
(D5+E5), however, the result from the original formula, 100, copies into the
cell instead of the result for the new row, say 74. I tried copy, paste
special, formula, without success. Any help?

 

[Guest]

If the formula adjusted, but the result did not adjust then:

Tools > Options... > Calculate > automatic