In your data numbers are stored in text format so sum function wont work.
use text to Column
1. select the number column
2. go to "Data tab" - "Text to Columns"
3. click Next, Next and Finish
Moderator removed promo link
Long time user of Excel 2000. I cannot figure out something. I have a workbook that has rows of numbers. Normally if you click and drag across the numbers, the numbers will show a sum at the bottom right corner.
On some rows this works. On another row it doesn't. I have copied the format from the row that works to the row that doesn't work be they still wont add. I DO have auto calc turned on. What other protections could these rows of numbers have on them that is preventing them from adding up?