Excel AutoSum Not Working: 4 Possible Solutions

Method 1 – Changing the Cell Format

Steps:

  • Select all the cells from C5 to C9.
  • Go to the Number section under the Home tab and select the General format from the drop-down.

change cell format to solve excel autosum not working

  • Click cell C10 and click AutoSum under Formulas.

change cell format to solve excel autosum not working

  • Press Enter and this should perform the AutoSum operation properly.


Method 2 – Trying Shortcut from Keyboard

Steps:

  • Go to cell C10 and press Alt and = at the same time.

keyboard shortcut to solve excel autosum not working

  • Press Enter, and this will calculate the sum of the above cells.


Method 3 – Using SUM Function

Steps:

  • Double-click on cell C10 and insert the formula below:
=SUM(C5:C9)

sum function to solve excel autosum not working

  • Press the Enter key; this will find the Total for the above input prices inside cell C10.


Method 4 – Sum Using VBA Code

Steps:

  • Go to the Developer tab and select Visual Basic.

opening vba window to solve excel autosum not working

  • Select Insert in the VBA window and click on Module.

  • Type in the formula below in the new window:
Sub Test()
    Range("C10") = Application.WorksheetFunction.Sum(Range("C5:C9"))
End Sub

  • Open the macro from the Developer tab by clicking on Macros.

  • In the Macro window, select the Test Macro and click Run.

  • The VBA code should solve the problem and 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.
  • You 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.

Download Practice Workbook

You can download the practice workbook from here.


Related Articles


<< Go Back to Autosum in ExcelSum in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo