Adding a column of numbers

I have a large worksheet and have entered numbers in a
column. Numbers range in value from 255 to 300. When I
perform the +sum(a1.a12) function my result is 0. If I
touch a cell (a1) the result is A1s value and if I touch
another cell (a2) to result is the sum of A1 + A2. This
happens even if I copy the worksheet or a portion to a
blank work sheet.

Hi
some ideas:
- how are the cells formated
- is automatic calculation turned on?

-----Original Message-----
I have a large worksheet and have entered numbers in a
column. Numbers range in value from 255 to 300. When I
perform the +sum(a1.a12) function my result is 0. If I
touch a cell (a1) the result is A1s value and if I touch
another cell (a2) to result is the sum of A1 + A2. This
happens even if I copy the worksheet or a portion to a
blank work sheet.
.

Hi

It sounds to me like your 'numbers' are not numbers.
Try this:
Copy a blank unused cell.
Select your range and Edit / Paste Special . . . Add.
This will coerce your data to become numbers.

Hope this helps.
--
Andy.


wrote in message
...
I have a large worksheet and have entered numbers in a
column. Numbers range in value from 255 to 300. When I
perform the +sum(a1.a12) function my result is 0. If I
touch a cell (a1) the result is A1s value and if I touch
another cell (a2) to result is the sum of A1 + A2. This
happens even if I copy the worksheet or a portion to a
blank work sheet.

=TYPE(F6) - Will tel lyou what you have and it does sound like a "Type" problem.