Forum Discussion

Copper Contributor

Jun 10, 2018

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

Formulas and Functions

Jaybe1972

Copper Contributor

Jul 04, 2022

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__
Copper Contributor
Jul 05, 2022
Jaybe1972 Gotta be numbers or currency. Sometimes merged cells won't work either.
- Not_tech_Savvy
  Copper Contributor
  Jul 17, 2022
  @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.
  - sadeelanjum
    Copper Contributor
    Nov 07, 2022
    In my case, there was a 'space' with the number. Removing the 'space' fixed the issue for me.
- Jaybe1972
  Copper Contributor
  Jul 11, 2022
  Leonard__I know but that still won't work if you have spaces before the number. A lot of people have had this problem when copy/pasting from text documents and no amount of formatting will work unless the spaces are removed 🙂