# [Fixed!] Excel AutoSum Not Working (4 Possible Solutions)

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.

## 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.

Steps:

• 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.

Steps:

• 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. ### 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.

Steps:

• To begin this solution method, double-click on cell C10 and insert the formula below:
`=SUM(C5:C9)` • 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.

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. ## 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.

## Conclusion

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.

## Related Articles #### Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts  5 Excel Hacks You Never Knew  