How to Add Up Columns in Excel
This wikiHow teaches you how to add two or more columns together in an Excel document. You can use the SUM command on both Windows and Mac versions of Excel to do so. Open your Excel document. Double-click the Excel document that you want...
Method 1 of 2:
Using the Columns
- Open your Excel document. Double-click the Excel document that you want to edit. Doing so opens it in Excel.
- Determine which of your columns is the longest. In order to include all of the cells in the longest column, you'll need to know to which row the column extends.
- For example, if you have three columns and the longest one has values from row 1 through row 20, your formula will need to include rows 1 through 20 for each column you want to add even if this includes blank cells.
- Determine your beginning and ending columns. If you're adding the A column and the B column, for example, your beginning column is the A column and your ending column is the B column.
- Select a blank cell. Click the cell in which you want to display the sum of your columns.
- Enter the "SUM" command. Type =SUM( ) into the cell.
- Enter the cell range. In the parentheses, type in the beginning column's top cell number, type a colon, and type in the ending column's letter along with the longest column's ending row.
- For example, if you're adding columns A, B, and C, and your longest column stretches to row 20, you would enter the following: =SUM(A1:C20)
- Press ↵ Enter. Doing so will display the sum of all of the columns in your selected cell.
Method 2 of 2:
Using Separate Cells
- Open your Excel document. Double-click the Excel document that you want to edit. Doing so opens it in Excel.
- Click a cell below one of the columns you want to add. Doing so will place your cursor in the cell.
- Enter the "SUM" command. Type =SUM( ) into the cell.
- Enter the column's range. Type the top cell in the column, a colon, and the bottom cell in the column into the parentheses.
- For example, if you're adding values in the A column and you have data in cells A1 through A10, you would type in the following: =SUM(A1:A10)
- Press ↵ Enter. This will display the sum of the column in your selected cell.
- Create the sums of the other columns you want to add. Once you have the sum of each column below the columns in question, you can proceed.
- Select an empty cell. Click the cell in which you want to display the sum of the columns you're adding together.
- Add together the cells in which you created the sums of the columns. You can do this by entering each cell's letter and number into the "SUM" command.
- For example, if you have the sum of each column in cells A11, B23, and C15, you would type =SUM(A11,B23,C15) into the empty cell.
- Press ↵ Enter. Doing so will display the sum of all of the columns in your selected cell.
5 ★ | 1 Vote
You should read it
- Steps to lock columns in Excel
- How to delete, add columns in Excel
- Tips for handling columns in Microsoft Word
- How to Compare Data in Excel
- Format column text in Word
- How to split columns in Excel
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to fix columns in Excel
- How to split first and last names into 2 columns in Excel
- How to combine 2 columns Full name in Excel does not lose content
- How to Make a Spreadsheet in Excel
Maybe you are interested
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
Excel - Convert columns to rows in Excel
How to delete rows and columns in Excel with mouse or key
Instructions on how to break columns in Word simply and quickly
Column order in Excel is reversed, why and how to handle it?
Excel does not allow inserting additional columns and rows [FIXED]