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