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:
- Click your mouse in the cell in which you wish your result to appear
- Click the AutoSum button on the Home Tab or the Formulas Tab
- Highlight the range of cells you wish to add
- Press Enter.
To add some of the values in a column or row:
- Type an equal sign, type SUM, then type an opening parenthesis.
- Type or select the cell references you want to add. A comma (,) separates individual arguments that tell the function what to calculate
- 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