I've used AutoSum many times but have never had a problem. I decided to copy and paste columns from my online bank statement today into Excel, but when I try to use the Auto Sum feature, it comes to zero every time. I tried copying and pasting the the data into Notepad and then back into Excel, but that didn't work.

2018年6月10日 · 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 add. AUTOSUM IS NOT WORKING! Have done the following: Click on cell to show total. Click AutoSum > cursor through the row of cells to be added.

2020年4月28日 · I'm going to autosumm in excel, but it just gets zero. Have try to google, looked on youtube and to tried all the basic troubleshooting, but nothing works. Does this help?:- Use AutoSum to sum numbers - EXCEL 2010

2018年10月20日 · Excel is not adding any numbers that I enter after I've auto summed them. Even for very simple situations. if I put 10 in A1 and 10 in A2 and then autosum that column in cell A4, it will sum it up correctly to 20 but if I input 10 in A3, …

2012年5月23日 · Excel Top Contributors: HansV MVP - Andreas Killer - Ashish Mathur - Jim_ Gordon - Riny_van_Eekelen Choose where you want to search below Search Search the Community

2012年1月31日 · I am trying to use autosum to total a column. I have tried everything posted here but still no success, I just get the following: =sum(B3;B33). My cell is set at general. My calculation option is set

2016年6月14日 · Before Excel 2016 I use to be able to Auto Sum a row like C2:C24, then copy the formula and paste to other rows to automatically add that line of numbers such as D2:D24. When I do that now, it just copies the number that was in C2:C24, and does not do the Auto Sum feature giving me wrong numbers. This is very frustrating.

2018年6月30日 · Here is also a test you can run. Start a new file. In A1 type in 1 and in A2 type in 2. Go to A3 and AutoSum. I'm betting Excel puts in =Sum(A1:A2). You should get 3. Now to go A4 and put in =subtotal(9,A1:A2) and you should get 3 again. Feel free to share your file as long as there is no sensitive or confidential information and I'll look at it.

2022年2月28日 · Hans, I apologies I did have the spreadsheet filtered. I did what you suggested and unfiltered the sheet and now AutoSum is back working like it should. Thanks for you help. My brain must be telling me it's tie for a break. Have a great day.

2013年4月2日 · I've got the same problem using Microsoft Excel 2013. I've got a sum(L6:L35) giving me a sum of 84.5, yet, when I select them, the sum at the lower right corner of the status bar gives me 80 and when I add them up manually they add up to 80 as well!