k.baechtold wrote: > Thanks for your help! Of course this manner to add up works when I have > only one Column of numbers (i.e; the column A including a number of > figures). But I've created a doc with 2 columns, the first "A" with the > purposes of the sum, & then "B" column with the numbers, this is this one > I want to add up, but the 2 manners you gave me to add up dosen't works > this time! Maybe it is because these are numbers with a comma ...I don't > know.
It may be really the problem. First of all, OOo Calc has wonderful feature (which is not available in Excel, BTW) to distinguish between formula results, values, and strings -- select View/Value Highlighting and you will see strings in black, values in blue, and results of formulas in green. What color does you column B has? If it is blue, than everything should work. However, I do not understand what you want to add to what. To sum up all numbers in B column? If it is black, then make column C, where you put into the first column formula =VALUE(B1). Then select all area of column C as long as there are numbers in the column B (the cell with the formula should be on the top) and run Edit/Fill/Down (shortcut key is Ctrl-D). It should fill whole selected area with the formula from the top. Result should be that whole C area should be filled with the same numbers as in column B, but they would be blue (i.e., OOCalc would consider them numbers and not strings). Best, Matej -- Matej Cepl, http://www.ceplovi.cz/matej/blog/ GPG Finger: 89EF 4BC6 288A BF43 1BAB 25C3 E09F EF25 D964 84AC The difference between death and taxes is death doesn't get worse every time Congress meets -- Will Rogers --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
