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 Rylah Hello! It happened because your numbers were in text format. I had to multiply two columns. I derived the first column by multiplying two other columns using the IMPRODUCT function. Maybe that's why Excel thought the result was a text. So, instead, I multiplied using the usual formula method, =B1*C1. The resultant number was in number format! AutSum worked perfectly fine then.
Incorrect. Cells are in General format.
