You can use the following methods to sum non-contiguous cells in Excel:

**Method 1: Sum Non-Contiguous Cells**

=SUM(A2, A6, A11)

This particular formula will calculate the sum of the values in cells A2, A6, and A11.

**Method 2: Sum Non-Contiguous Cells and Contiguous Cells**

=SUM(A2:A7, A10, A12)

This particular formula calculates the sum of the values in the range A2 to A7 along with the values in cell A10 and A12.

The following examples show how to use each formula in practice with the following dataset in Excel:

**Example 1: Sum Non-Contiguous Cells in Excel**

We can type the following formula into cell C2 to calculate the sum of the values in cells A2, A6, and A11:

=SUM(A2, A6, A11)

Once we press **Enter**, the sum of the values in these cells will be shown:

The sum of this non-contiguous set of cells is **23**.

**Example 2: Sum Non-Contiguous Cells and Contiguous Cells**

We can type the following formula into cell C2 to sum the values of some non-contiguous cells and some contiguous cells:

=SUM(A2:A7, A10, A12)

Once we press **Enter**, the sum of the values in these cells will be shown:

The sum of these cells is **71**.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Sum Cells with Text and Numbers

Excel: How to Sum If Not Blank

Excel: How to Use SUMIF with OR