Sum function failure

H

HighFlier22

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.
 
P

Peo Sjoblom

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


--


Regards,


Peo Sjoblom
 
G

Gord Dibben

Is Calculation set to Automatic in Tools>Options>Calculation?


Gord Dibben MS Excel MVP
 
M

Max

HighFlier22 said:
It's pretty simple: =SUM(I710:L710)
Click to expand...

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)
 
Top