In this tutorial, I am going to show you 4 possible solutions to excel AutoSum not working. You can quickly use these fixes even in large datasets to solve AutoSum problems. Throughout this tutorial, you will also learn some important excel tools and functions which will be very useful in any excel related task.
Download Practice Workbook
You can download the practice workbook from here.
4 Possible Solutions If Excel AutoSum Is Not Working
We have taken a concise dataset to explain the steps clearly. The dataset has approximately 6 rows and 3 columns. For all the datasets, we have 2 unique columns which are Item and Price. Although we may vary the number of columns later on if that is needed.
1. Changing the Cell Format
One of the commons for AutoSum not working in excel is that there might be a wrong data format set up in the dataset. Let us see how to tackle this problem.
- In the begining, select all the cells from C5 to C9.
- Now, go to the Number section under the Home tab and select the General format from the drop-down.
- Next, click on cell C10 and click on AutoSum under Formulas.
- Finally, press Enter and this should perform the AutoSum operation properly.
2. Trying Shortcut from Keyboard
You can try this fix as a quick and effective alternative to the AutoSum feature in excel if it is not working. Follow the steps below.
- To begin with, go to cell C10 and press Alt and = at the same time.
- Then, press the Enter key and immediately this will calculate the sum of the above cells.
Read More: [Solved!] Excel AutoSum Is Not Working and Returns 0
3. Using SUM Function
The SUM function in excel calculates the arithmetic addition of the values that we supply as the inputs. We can use this function to perform the sum operation if the AutoSum is not working. Let us see how to do this.
- To begin this solution method, double-click on cell C10 and insert the formula below:
- Next, press the Enter key and consequently, this will find the Total for the above input prices inside cell C10.
4. Sum Using VBA Code
Another way to replicate the function of the AutoSum feature if it is not working is to use VBA in excel. Follow the below steps.
- First, go to the Developer tab and select Visual Basic.
- Now, select Insert in the VBA window and click on Module.
- Furthermore, type in the formula below in the new window:
Sub Test() Range("C10") = Application.WorksheetFunction.Sum(Range("C5:C9")) End Sub
- Then, open the macro from the Developer tab by clicking on Macros.
- After that, in the Macro window, select the Test Macro and click Run.
- Consequently, the VBA code should solve the problem and properly do the sum operation.
Read More: How to Use AutoSum In Excel (4 Easy Ways)
Things to Remember
- Use the shortcut Alt+F11 to open the VBA window as an alternative.
- If you are a Mac user, you can use the option key instead.
- We can insert individual values or a range of cells inside the SUM function.
- Note that this function can take up to 255 arguments as inputs.
- Use the Alt+F8 shortcut keys to open the Macros window to see the macro.
I hope that you were able to apply the methods that I showed in this tutorial on 4 possible solutions to excel AutoSum not working. As you can see, there are quite a few ways to fix this problem. So wisely choose the method that suits your situation best. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.