How do I add a column of numbers (auto sum)??

  • Thread starter Thread starter tonysaw
  • Start date Start date
T

tonysaw

When I highlight a column of numbers, I get the right formula, but return a
value of 0??
 
So you get something like =SUM(A1:A10) but this displays 0?
Sounds like they are not really numbers but text
Try
1) format the range as numbers
2) copy an empty cell, select the range of interest and use Edit | Paste
Special with Add specified
--this trick converts text digits to numbers most of the time
3) if all else fails, after formatting the range as numbers, retype the
numbers
best wishes
 
You must log in or register to reply here.

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

Formula (or code) return the largest number of duplicates in a list. 16
Array function - I think! 8
Formula appears, but its function is not performed????? 1
Time Sum in Excel 1
excel sum function 2
Sum if not blank 2
Sum a column 2
Sum every Nth Row (almost working) 1

Back
Top