I have a large (over 500 row) spreadsheet for tabulating simple data. The Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted location
it delivers the number from the location it is copied, ignoring the data in
the range it is supposed to add up.

Perhaps you should post your formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HighFlier22" wrote in message
...
I have a large (over 500 row) spreadsheet for tabulating simple data. The
Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted
location
it delivers the number from the location it is copied, ignoring the data
in
the range it is supposed to add up.

It's pretty simple: =SUM(I710:L710)

"Don Guillett" wrote:

Perhaps you should post your formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HighFlier22" wrote in message
...
I have a large (over 500 row) spreadsheet for tabulating simple data. The
Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted
location
it delivers the number from the location it is copied, ignoring the data
in
the range it is supposed to add up.

Is Calculation set to Automatic in ToolsOptionsCalculation?


Gord Dibben MS Excel MVP

On Sat, 24 May 2008 15:48:00 -0700, HighFlier22
wrote:

It's pretty simple: =SUM(I710:L710)

"Don Guillett" wrote:

Perhaps you should post your formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HighFlier22" wrote in message
...
I have a large (over 500 row) spreadsheet for tabulating simple data. The
Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted
location
it delivers the number from the location it is copied, ignoring the data
in
the range it is supposed to add up.

"HighFlier22" wrote:
It's pretty simple: =SUM(I710:L710)

If it's not calc mode issue, maybe the "numbers" in I710:L710 are text
numbers? Try this which will coerce all to real numbers, array-entered (press
CTRL+SHIFT+ENTER to confirm the formula):
=SUM(I710:L710+0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Highlight the formula in the formula bar then copy and paste it


--


Regards,


Peo Sjoblom



"HighFlier22" wrote in message
...
I have a large (over 500 row) spreadsheet for tabulating simple data. The
Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted
location
it delivers the number from the location it is copied, ignoring the data
in
the range it is supposed to add up.

Is Calculation set to Manual
Try pressing F9
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"HighFlier22" wrote in message
...
I have a large (over 500 row) spreadsheet for tabulating simple data. The
Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted
location
it delivers the number from the location it is copied, ignoring the data
in
the range it is supposed to add up.