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
 
H

HighFlier22

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

Don Guillett said:
Perhaps you should post your formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
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)

---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum with matrix functions? 8
Ignore text but not numerics on SUM() function 1
How to ignore text on SUM() function... 16
Subtotal Function is Inconsistent 4
Problem with LARGE function 3
Using paste link 1
Help with finding numbers within text and summing 2
Help with a SUM function... 2

Top