The result will be displayed in the cell as shown in the screenshot above. Once you press the Enter button on your keyboard Excel will store the total in the cell. Once the Enter button is pressed on your keyboard, Excel will show the result of the formula Notice how the cells in the formula have been highlighted in different colours as I typed the formula. In the above example, I selected cell C2 first, then the plus sign (+) and then cell C3 and then the plus sign (+) and so on until I selected cell C9. Next enter an equals sign (=) and then select the first cell you want to add, then enter a plus sign (+) and then select the next cell you want to add and so on. In this example, I want the total sales to be in cell C11. First, you need to select the cell where you want the answer to be. You can sum a column in Excel using the plus sign (+). How to Sum a Column in Excel using Addition You can sum a column using the + sign The overall goal is to sum the total sales in column C. I will use the data in the screenshot above which shows a list of Sales people with their sales in column C for all the examples of how to sum a column in Excel. In this post, I will show you 5 simple and easy ways on how to sum a column in Excel. For instance, you may have a list of sales or prices of products you want to sum in a column. One of the main reasons people use Excel is to sum values in a column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |