Autosum returns an incorrect zero value on the selected cells

G

Guest

When i press autosum at the bottom of a range of cells the formula appears in
the cell but does not auto suggest cells to calculate. then even when i
highlight the cells and press enter excell returns a zero value.
However, if i enter the individual cells in the formula i.e. "=A1+A2+A3", it
will give me the correct total.
does anyone have any ideas whats going wrong.
ps. when i tried autosum in a seperate column it worked perfectly,
 
J

Jerry W. Lewis

Likely the cells are text instead of numbers. SUM will ignore text, but
+ will coerce text to numbers if possible. =COUNT(range) will return
zero if there are no numeric values in the range. Copy an empty cell,
select the range in question, Edit|Paste Special|Add to force conversion
to numbers.

Jerry
 
G

Guest

Ok, I have just discovered that what i was actually working with was an
imported report from MS Access that my line manager saved as an Excell sheet.
Autosum seems to work when i re enter the figures manually in the cells, but
not if i copy and then paste them as values.

I would be very gratefull if anyone have any ideas, because its going to be
a long process to retype all the data ?
 
G

Guest

sorry Jerry I didnt see your reply before i added to my original post. I did
what you said and now all is hunky dory. thanks for your help.
Regards
Wayne
 

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

autosum refusal to sum highlighted range 4
AutoSum sometimes doesn't work? 5
Divide by the minimum non-zero number in a range of cells 21
auto format 0
An odd problem with SUM(A:B) and AutoSum 2
Problem calculating 3
Bizarre Excel 03 Problem - autosum not updating when cells are cha 2
To get an average of a column of numbers not zero/blank cells 4

Top