Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum error
i'm trying to sum all contents in A:A, i used the funtion =sum(A:A) the
result is sum(A:A) exacly what it says, no result. can anyone help figure out whats wrong, pleaseee. Thank You. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum error
You need to put an = sign in front of the formula when you type it
into the cell, otherwise Excel will see it as text. Alternatively, the cell with that formula in might have been pre- formatted as text - if so, use Format | Cells | Number tab to change it to General or Number, and then re-enter the formula. Hope this helps. Pete On Jan 31, 2:52*pm, anier614 wrote: i'm trying to sum all contents in A:A, i used the funtion =sum(A:A) the result is sum(A:A) exacly what it says, no result. can anyone help figure out whats wrong, pleaseee. Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |