Autosum doesn't work. How do I get column total?
in [General]
|
Prev: Are there shortcut keys in Excel for Cell Alignment?
Next: Data, Text to Columns, has commas in the text, plus as a delimeter
From: BK on 20 May 2010 08:15 I am doing an excel spreadsheet at work. The column I need to total seems to have a fault, and autosum doesn't work. What can I do?
From: trip_to_tokyo on 20 May 2010 08:25 Try it in another column and / or Workbook and see what happens there. "BK" wrote: > I am doing an excel spreadsheet at work. The column I need to total seems to > have a fault, and autosum doesn't work. > What can I do?
From: MimiS on 20 May 2010 09:36
It may be due to some blank spaces being in the numbers column or before or after a number that's in the column. Save your work, then highlight relevant range and do an Edit/Replace. Find (single space) and replacing with (leave box empty). I see this when downloading and importing reports from our accounting system. "BK" wrote: > I am doing an excel spreadsheet at work. The column I need to total seems to > have a fault, and autosum doesn't work. > What can I do? |