How to Sum Columns in Excel: 5 Steps (with Pictures)

Table of contents:

How to Sum Columns in Excel: 5 Steps (with Pictures)
How to Sum Columns in Excel: 5 Steps (with Pictures)

Video: How to Sum Columns in Excel: 5 Steps (with Pictures)

Video: How to Sum Columns in Excel: 5 Steps (with Pictures)
Video: C++ Style Guide | Writing Clean C++ Code | Formatting Conventions 2024, May
Anonim

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

Add Up Columns in Excel Step 1
Add Up Columns in Excel Step 1

Step 1. Run your file in Excel

Select the worksheet file you want and open it in Microsoft Excel.

Add Up Columns in Excel Step 2
Add Up Columns in Excel Step 2

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.

Add Up Columns in Excel Step 3
Add Up Columns in Excel Step 3

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)

Add Up Columns in Excel Step 5
Add Up Columns in Excel Step 5

Step 1. Run Excel

You have to select the file you want to open in the application. Double click to run it.

Add Up Columns in Excel Step 6
Add Up Columns in Excel Step 6

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."

Recommended: