21.7 C
London
Wednesday, July 23, 2025
HomeSoftware TutorialsExcelHow to Sum Non-Contiguous Cells in Excel (With Examples)

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

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories