AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2023
Categories |
Back to Blog
![]() ![]() 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. 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. 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. ![]() You can download this SUM Cells Excel Template here – SUM Cells Excel Template Example #1 ![]()
0 Comments
Read More
Leave a Reply. |