Table of Contents
Calculating the sum of non-contiguous cells in Excel can be achieved by using the SUM function. This function allows you to add up values from multiple cells that are not necessarily next to each other. To do this, simply select all the cells that you want to include in the sum, then type “=SUM(” in the cell where you want the result to appear. Next, select the cells you want to add together, separated by a comma, and close the function with a closing bracket. This will give you the total sum of all the selected cells. Additionally, you can also use the AutoSum button in the Home tab to automatically calculate the sum of the selected cells. This method can be useful when working with large sets of data or when you need to add up values from different parts of your spreadsheet.
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
=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.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I calculate the sum of non-contiguous cells in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-calculate-the-sum-of-non-contiguous-cells-in-excel/
stats writer. "How can I calculate the sum of non-contiguous cells in Excel?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-calculate-the-sum-of-non-contiguous-cells-in-excel/.
stats writer. "How can I calculate the sum of non-contiguous cells in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-calculate-the-sum-of-non-contiguous-cells-in-excel/.
stats writer (2024) 'How can I calculate the sum of non-contiguous cells in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-calculate-the-sum-of-non-contiguous-cells-in-excel/.
[1] stats writer, "How can I calculate the sum of non-contiguous cells in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I calculate the sum of non-contiguous cells in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.