Worksheet functions

[Tomj]

I have an Excel worksheet in which I cannot add several
columns of numbers using the sum function. The result
keeps coming up as zero. It probably is a formatting
error of some sort. The worksheet in question was
obtained by cutting and pasting portions of several other
worksheets, then sorting anad rearranging the data, which
is in rows. Running Windows XP and Excel 97. Computer
memoruy is adequate.

 

[Frank Kabel]

Hi
try the following:
- select an empty cell and copy this cell
- select your data which you want to sum
goto 'Edit - Paste Special' and choose 'Add'

Now try the sum formula again

 

[Andy B]

Hi

It sounds like your cells are not numbers. They may have leading/trailing
spaces, or they may have been put into cells formatted as text. You could
try a helper column with
=TRIM(A2)
in, and fill this down. Once this is done, copy a blank unused cell, select
your range and Edit / Paste Special . .. Add
You then need to 'fix' these values. Select the range, copy , Paste Special
.. . Values