How to Add Up Columns in Excel

Using Separate Cells

1. 
   Open your Excel document. Double-click the Excel document that you want to edit. Doing so opens it in Excel.
2. 
   Click a cell below one of the columns you want to add. Doing so will place your cursor in the cell.
3. 
   Enter the "SUM" command. Type =SUM( ) into the cell.
4. 
   Enter the column's range. Type the top cell in the column, a colon, and the bottom cell in the column into the parentheses.

   1. 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)
5. 
   Press ↵ Enter. This will display the sum of the column in your selected cell.
6. 
   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.
7. 
   Select an empty cell. Click the cell in which you want to display the sum of the columns you're adding together.
8. 
   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.

   1. 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.
9. 
   Press ↵ Enter. Doing so will display the sum of all of the columns in your selected cell.