Alternatively to Bernard's original and "alternative" - if you *don't* want
to disable the Extend feature (which does prove useful) - you can edit your
formula to read as:

SUM($D$5:$D$10)

This makes the range reference absolute and prevents the function from
automatically including the new entries in the column.
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"Bernard Liengme" wrote in message
...
Alternative:
place formula in another column
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Richard Wrigley" wrote in message
...
Greetings from Norfolk

This may be a silly question!
I set up SUM(D5:D10) and put the result in D15.
When trying out the sheet I made entries (numeric) in D5, D6...D10 all
OK.
I then made entries in D11, D12, D13 and D14; The formulae in D15
modified
itself (!!??) to include these values in the Summation. i.e. the answer
was
progressively D5 to D10, D5 to D11, D5 to D12 etc.
Can anybody explain and assist in preventing this occuring again.
Ilooked
through the various settings for Excel, but could not find any that
appear
relevant !

--
Richard.

"I have yet to see any problem, however complicated, which when looked at
in
the right way, did not become still more complicated"
Poul Anderson