Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

numbers won't sum

Posted by Randal Byrd on October 28, 2001 9:13 AM
I have a column of numbers that I'm trying to sum. No matter what I do, it sums to zero. I've tried formatting the cells to general numbers, numbers with decimal places, etc...and nothing I do changes the results. Still reads all the values as zero and gives a zero sum? HELP!

Thanks,
Randal in Houston


Re: numbers won't sum

Posted by JayD on October 28, 2001 9:30 AM
Are you sure they are numbers and not text? Try this to find out (assumes column A is what you want to sum).

In B1 enter =value(A1) and copy it down to the other rows. After that sum column B & see what happens.


Jay


Re: numbers won't sum

Posted by Aladin Akyurek on October 28, 2001 10:19 AM
Activate an empty cell, activate Edit|Copy, activate Edit|Paste Special and select Add. Now the SUM formula should work.

Aladin

=========


Re: numbers won't sum

Posted by Qroozn on October 28, 2001 1:09 PM
check tools/options/calculations - calculation should be set to automatic not manual


Re: numbers won't sum

Posted by Randal Byrd on October 28, 2001 7:22 PM
I found an answer later in this board - - - I clicked on the column and then chose, DATA - Text to Columns - Finish

That took care of it. Thanks to all who offered help.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.