Microsoft Excel is an electronic spreadsheet application. This program is suitable for storing and organizing data, and has various tools to help you do this. The SUM function in Excel allows you to add up individual columns, rows, or cells.
Step
Method 1 of 2: Traditional Command
Step 1. Run your file in Excel
Select the worksheet file you want and open it in Microsoft Excel.
Step 2. Select a cell
You must select the cells that will be used to display the sum. This can be placed at the bottom of the column that you use to sum the values in that column.
Step 3. Type the sum command in the cell
Click the cell you selected. In the line of text at the top (the place used to display the text in the cell) type =SUM(AX:AY).
The variable A is the letter of the row you want, X is the variable from the cell you used to start your addition, and Y is the last cell in your sum
Method 2 of 2: Shortcut (Shortcut)
Step 1. Run Excel
You have to select the file you want to open in the application. Double click to run it.
Step 2. Alternatively, you can type =SUM(then select the first cell you want to sum)
Hold down "Shift" then scroll down to the last cell in your sum and click that cell. Then press "Enter."