If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Adding a column of numbers
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. . |
#3
|
|||
|
|||
Adding a column of numbers
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. |
#4
|
|||
|
|||
Adding a column of numbers
=TYPE(F6) - Will tel lyou what you have and it does sound like a "Type" problem.
|
Thread Tools | |
Display Modes | |
|
|