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

• Click cell C10 and click AutoSum under Formulas.

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

• 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)`

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

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

## Related Articles

<< Go Back toÂ Autosum in Excel |Â Sum in ExcelÂ

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF