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...
Hi. Thank you, I´m still not able to do it though. Because b) i found, but to change to numbers doesn´t seem to work and nothing new happens.Deleted
Excel is fussing because you're not telling what cells to sum. You need a range of cells in your formula. Instead of =SUM(), you need something like =SUM(N2:N20) or whatever your range is.