sum formula does not calculate
 

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!

<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!
==============================================

"Dena X" <Dena wrote in message
...
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!

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

"Dena X" <Dena wrote in message
...
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!

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.

"Paul B" wrote:

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

"Dena X" <Dena wrote in message
...
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!