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.
alphamanny , I think we addressed the formatting issue, where many had formatted to number or currency, where the auto sum still did not work. In my case, I had formatted to number or currency and still the auto sum would not work, until I copy pasted into MS Word, cleared all formatting, then pasted back into Excel. FYI
barrymdho
Is this the only solution ie copying the values from xcel and then pasting them in .doc and repeat the process to excel? I tried other options but this is the only one which works......
