sum formula does not calculate

D

Dena X

In cell d6 I am summing together d1:d5 using =sum(d1:d5).
it does not calculate correctly unless I type in the cell and F9 it.
Further, when I drag the formula right despite the next cell saying
=sum(E1:E5) it is returning the value of column D.

Any idea why the sum is not refreshing and why the drag right doesn't work?

Thanks!
 
R

RagDyer

<Tools> <Options> <Calculation> tab,
And under Calculation, place a check in "Automatic".

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
P

Paul B

Dena, sounds like calculation is set to manual, tools, options, calculation,
check automatic
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
C

Cheryl R.

Check to make sure that all values in the column were entered as numeric. If
they were entered (or imported) as text and you change the column format to
numeric, they retain their text format.
 
Top