# How to Do a Sum in Microsoft Excel

Microsoft Excel is a powerful tool widely used in business, education, and everyday tasks for its ability to perform calculations and organize data efficiently. One basic yet essential Excel function is performing a sum, and knowing how to add numbers quickly can save you time and enhance your productivity.

## How to Do a Sum in Microsoft Excel

Summing numbers in Excel is a fundamental skill that can help you efficiently manage and analyze data. Here’s how to perform a sum in Excel using the SUM function and AutoSum feature:

Launch Excel and open the sheet where you want to perform the sum. Ensure the data you want to add is properly entered in the cells.

• ### Step 2. Select the Cell for the Result

Click on the cell where you want the sum to appear. This is where the total of your selected numbers will be displayed.

• ### Step 3. Use the SUM Function

Type =SUM( in the selected cell. Click and drag to select the range of cells you want to sum. Close the parenthesis ) and press “Enter.” For example, =SUM(A1:A10) sums all values from cell A1 to A10.

• ### Step 4. Use the AutoSum Feature

Click on the cell where you want the sum to appear. Go to the “Home” tab on the ribbon. Click the “AutoSum” button (Σ symbol) in the Editing group. Excel will automatically select a range of cells it thinks you want to sum. Adjust the range if necessary. Press “Enter” to display the sum.

• ### Step 5. Verify Your Result

Check the cell where you entered the sum function or used AutoSum to ensure it displays the correct total.

You may also find valuable insights in the following articles offering tips for Microsoft Excel:

Note

## FAQs

### How do I sum a column in Excel?

Select the cell where you want the total, use =SUM(column_range), and press Enter.

### Can I sum non-adjacent cells in Excel?

Yes, use =SUM(cell1, cell2, cell3, …) and press Enter.

### What is the AutoSum function?

AutoSum is a feature that quickly adds a range of cells with one click.

### How do I fix a #VALUE! error in my SUM formula?

Ensure all cells in the range contain numeric values and no text.

### Can I use SUM with filtered data?

Yes. Use the SUBTOTAL function instead of SUM to include only visible cells.