Add the Values in Rows or Columns in Excel

Question

How do you add the values in rows or columns in Excel?

Answer

Use the SUM function, which is prewritten formula, to add all the values in a row or column: 

  1. Click your mouse in the cell in which you wish your result to appear 
  2. Click the AutoSum button on the Home Tab or the Formulas Tab 
  3. Highlight the range of cells you wish to add 
  4. Press Enter.

To add some of the values in a column or row: 

  1. Type an equal sign, type SUM, then type an opening parenthesis. 
  2. Type or select the cell references you want to add. A comma (,) separates individual arguments that tell the function what to calculate 
  3. Type a closing parenthesis, and then press ENTER.

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.