How to Sum Non-Contiguous Cells in Excel (With Examples)


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

Leave a Reply

Your email address will not be published. Required fields are marked *