| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum doesn't work. How do I get column total?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autosum doesn't work. How do I get column total?
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autosum doesn't work. How do I get column total?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to total a column of cells without using Autosum | Excel Discussion (Misc queries) | |||
| how do I total a column with hours and minutes? SUM doesnt work | Excel Worksheet Functions | |||
| calculated item does not work in grand total column- Pivot | Excel Discussion (Misc queries) | |||
| calculated item does not work in grand total column in Pivot | Excel Discussion (Misc queries) | |||
| How do I Autosum a running column total in excel? | Excel Worksheet Functions | |||
Linear Mode
