Forum Discussion
AutoSum not working
I've been using Excel with AutoSum for many years. Recently installed Office 365 and pre-existing spreadsheets are working as usual. Have just set up a brand new spreadsheet with lots of cells to a...
Margot RylahI am not sure if this has been resolved yet but I have just had the same issue and found the problem was having spaces or tabs before the number I wanted to sum. Deleting the spaces allowed the cell to be formatted correctly to numbers and autosum started working again.
@Leonard My auto sum does not auto sum as information is entered in excel. All cells are in account format. Should it auto sum as the info is entered or am I expecting too much? I tried to follow all the above info but as my username says not tech savvy.
In my case, there was a 'space' with the number. Removing the 'space' fixed the issue for me.
- Yes, they should autosum in accounting format. Have you used autosum before and do you know how to use it ? Highlight all the cells you want to sum and click autosum and it should add up in the next cell below.
