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...
Make sure there are no spaces in your numbers!
I found that, due to copying and pasting from a banking website, i had some extra blank spaces at the ends of numbers. They don't figure into the autosum function. Simply paste your column of numbers into Word or similar, and use the find and replace function to find all the spaces and replace with nothing. Re-paste back into excel and voila!