Adding a column of numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top