HomeApplicationOffice informationHow to Add Up Columns in Excel

How to Add Up Columns in Excel

Method 1 of 2:

Using the Columns

  1. How to Add Up Columns in Excel Picture 1
    Open your Excel document. Double-click the Excel document that you want to edit. Doing so opens it in Excel.
  2. How to Add Up Columns in Excel Picture 2
    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.
    1. 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.
  3. How to Add Up Columns in Excel Picture 3
    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.
  4. How to Add Up Columns in Excel Picture 4
    Select a blank cell. Click the cell in which you want to display the sum of your columns.
  5. How to Add Up Columns in Excel Picture 5
    Enter the "SUM" command. Type =SUM( ) into the cell.
  6. How to Add Up Columns in Excel Picture 6
    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.
    1. 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)
  7. How to Add Up Columns in Excel Picture 7
    Press ↵ Enter. Doing so will display the sum of all of the columns in your selected cell.
Method 2 of 2:

Using Separate Cells

  1. How to Add Up Columns in Excel Picture 8
    Open your Excel document. Double-click the Excel document that you want to edit. Doing so opens it in Excel.
  2. How to Add Up Columns in Excel Picture 9
    Click a cell below one of the columns you want to add. Doing so will place your cursor in the cell.
  3. How to Add Up Columns in Excel Picture 10
    Enter the "SUM" command. Type =SUM( ) into the cell.
  4. How to Add Up Columns in Excel Picture 11
    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. How to Add Up Columns in Excel Picture 12
    Press ↵ Enter. This will display the sum of the column in your selected cell.
  6. How to Add Up Columns in Excel Picture 13
    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. How to Add Up Columns in Excel Picture 14
    Select an empty cell. Click the cell in which you want to display the sum of the columns you're adding together.
  8. How to Add Up Columns in Excel Picture 15
    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. How to Add Up Columns in Excel Picture 16
    Press ↵ Enter. Doing so will display the sum of all of the columns in your selected cell.
5 ★ | 1 Vote
columncellsumcolumns

You should read it

May be interested

  • How to Search for Words in ExcelPhoto of How to Search for Words in Excel
    an excel document can be overwhelming to look through. thankfully, you can use the search function to conveniently locate a particular word, or group of words, in an excel worksheet. launch ms excel. do this by clicking on its icon in your...
  • How to Unshare an Excel WorkbookPhoto of How to Unshare an Excel Workbook
    this wikihow teaches you how to stop sharing a microsoft excel document on desktop, iphone, and android platforms. open excel. it's a green app with a white 'x' on it. to open a shared document that you wish to unshare, you'll need to load...
  • How to Use the Sum Function in Microsoft ExcelPhoto of How to Use the Sum Function in Microsoft Excel
    using the sum function in excel is an easy way to save yourself lots of time. decide what column of numbers or words you would like to add up
  • How to Integrate Large Data Sets in ExcelPhoto of How to Integrate Large Data Sets in Excel
    these instructions will show you how to approximate integrals for large data sets in microsoft excel. this can be particularly useful when analyzing data from machinery or equipment that takes a large number of measurements—for example, in ...
  • How to Make Tables Using Microsoft ExcelPhoto of How to Make Tables Using Microsoft Excel
    this wikihow teaches you how to create a table of information in microsoft excel. you can do this on both windows and mac versions of excel. open your excel document. double-click the excel document, or double-click the excel icon and then...
  • How to Create a Random Sample in ExcelPhoto of How to Create a Random Sample in Excel
    this wikihow teaches you how to generate a random selection from pre-existing data in microsoft excel. random selections are useful for creating fair, non-biased samples of your data collection. open the microsoft excel program. you can...

Office information