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...
@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.