Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
numbers won't sumPosted 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!
Randal in Houston
Re: numbers won't sumPosted 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.
Re: numbers won't sumPosted 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.
Re: numbers won't sumPosted 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 sumPosted 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.