ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autosum doesn't work. How do I get column total? (https://www.excelbanter.com/excel-discussion-misc-queries/264170-autosum-doesnt-work-how-do-i-get-column-total.html)

bk

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?

trip_to_tokyo[_3_]

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?


MimiS

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?



All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com