# How to Sum Non-Contiguous Cells in Excel

Summing non-contiguous cells in Excel is quite simple, and there are several ways to do this. In this guide, we will go through two methods: using the SUM function and using the AutoSum feature.

## Method 1: Using the SUM function

- Click on the cell where you want the total sum to appear.
- Type
`=SUM(`

in the cell. - Click on the first non-contiguous cell you want to include in the sum.
- Hold the
`Ctrl`

key on your keyboard and click on each additional non-contiguous cell you want to include in the sum. The cell addresses will be added to the formula, separated by commas. - Close the parentheses by typing
`)`

and press`Enter`

to complete the formula. - The sum of the non-contiguous cells will be displayed in the cell you originally clicked.

## Method 2: Using the AutoSum feature

- Click on the cell where you want the total sum to appear.
- Go to the "Home" tab in the Excel toolbar.
- In the "Editing" group, click on the "AutoSum" button (it looks like a Greek sigma symbol ∑).
- Excel will automatically suggest a range of cells to include in the sum. Delete this suggested range.
- Click on the first non-contiguous cell you want to include in the sum.
- Hold the
`Ctrl`

key on your keyboard and click on each additional non-contiguous cell you want to include in the sum. The cell addresses will be added to the formula, separated by commas. - Press
`Enter`

to complete the formula. - The sum of the non-contiguous cells will be displayed in the cell you originally clicked.

## Example

Let's say you want to sum the values in cells A1, A3, and A5. Follow the steps below using either method:

- Click on the cell where you want the total sum to appear, for example, A7.
- Using the SUM function, type
`=SUM(`

, or using the AutoSum feature, click on the "AutoSum" button and delete the suggested range. - Click on cell A1, then hold the
`Ctrl`

key and click on cells A3 and A5. - Close the parentheses for the SUM function by typing
`)`

or simply press`Enter`

for the AutoSum method. - The sum of the non-contiguous cells A1, A3, and A5 will be displayed in cell A7.

Did you find this useful?