The former sum task essentially means summing across columns, while the later sum task essentially means summing across the rows. Our task is to obtain total sales figures for each of the products for all the years and total sales figures for all the products. The sales figures for different products for these years are given, as can be seen in the below screenshot. We have product sales data for five different years, from 2014 to 2018. In this example, we will require to sum across rows as well as columns because both sums stand meaningful. The context governs the summing of cells, and we have seen it with examples. In the first example we discussed, we summed cells across rows, and in the second column, we summer cell across columns. In this example, summing marks for each subject across different students is not meaningful, as a total of marks for all students is never desired. If both the figures match then, we have successfully managed to sum cells to obtain total marks for each student. Note that to verify that the right correct totals have been obtained, just select the range we had used for addition and see the sum in the status bar. If implemented correctly, we shall obtain the right results.Īs can be seen in the following screenshot, we obtained the total marks for each of the students using the SUM function, following the above procedure properly. Once the requisite range is passed as an argument, close the function and press Enter Key. Observe how the function has been implemented. We implemented the SUM function to sum cells across the range containing marks of five subjects, as shown in the following screenshot. In the Total columns, we want a total of five subjects for each student. The following screenshot shows the marks of data for students. Once implemented in the first cell, the function then will have to be copied down across all the requisite cells. This we will do by adding the marks for five marks using the SUM function. Now, our task is to obtain total marks for each student. Here, we have marks for five different subjects for a certain number of students. In the cell, we got the total sales as a number, and in the formula bar, we can see the formula that sums up the numeric contents in the mentioned range. The following screenshot shows the cells summed up using the SUM function. If we pass the argument (range of cells containing numeric values) properly into the SUM function, then we get the correct result.
![how to sum a column in excel with inch marks how to sum a column in excel with inch marks](https://cdn.extendoffice.com/images/stories/doc-excel/sum-numbers-with-units/doc-sum-numbers-with-same-unit-1.png)
Once done, complete the bracket and press Enter Key. We can pass individual numbers separated by commas or pass range(s) in the SUM function. Note, here we selected all those cells that contain sales figures for respective products. The SUM function will be implemented as shown below. Using the SUM function, we will obtain total sales.
![how to sum a column in excel with inch marks how to sum a column in excel with inch marks](https://i0.wp.com/support.content.office.net/en-us/media/1a57f414-aaa7-4e09-bdf8-20a5f2e35685.jpg)
This will, essentially, be sales obtained after adding sales for all the products. The dataset is as shown in the following screenshot. Their product IDs have represented the products. We have Sales data for various products for a particular time period.
How to sum a column in excel with inch marks download#
You can download this SUM Cells Excel Template here – SUM Cells Excel Template Example #1