As Seen on TechCrunch: Finofo Raises \$1.65M CAD!

## How to Add Up a Column in Excel: Step-by-Step Guide

If you're working with data in Excel and need to sum up a column of numbers, Excel provides several methods to accomplish this task. Here's a step-by-step guide.

#### Method 1: Using the SUM Formula

2. Click on the cell where you want the sum of the column to appear.
3. Type the following formula: =SUM(
4. Click on the first cell in the column you want to add up.
5. Type a colon (:).
6. Click on the last cell in the column you want to add up.
7. Complete the formula with ) and press Enter.
8. Excel will automatically calculate the sum of the selected column and display the result in the cell where you entered the formula.

#### Method 2: Using the AutoSum Feature

2. Click on the cell where you want the sum of the column to appear.
3. Click the AutoSum button on the Home tab of the ribbon.
4. Excel will automatically select the column of cells to the left of the selected cell.
5. Press Enter, and Excel will display the sum of the column in the selected cell.

#### Method 3: Using the SUM Function for Multiple Columns

2. Click on the cell where you want the sum of the columns to appear.
3. Type the following formula: =SUM(
4. Click on the first cell in the first column you want to add up.
5. Type a colon (:).
6. Click on the last cell in the first column you want to add up.
7. Type a comma (,).
8. Repeat steps 4-6 for each additional column you want to add up.
9. Complete the formula with ) and press Enter.
10. Excel will calculate the sum of the selected columns and display the result in the cell where you entered the formula.

#### Method 4: Using AutoSum for Multiple Columns

2. Click on the cell where you want the sum of the columns to appear.
3. Click the AutoSum button on the Home tab of the ribbon.
4. Excel will automatically select the columns of cells to the left of the selected cell.
5. Press Enter, and Excel will display the sum of the columns in the selected cell.

#### Adding Up a Row in Excel (Using AutoSum):

2. Click on the cell where you want the sum of the row to appear.
3. Click the AutoSum button on the Home tab of the ribbon.
4. Excel will automatically select the row of cells above the selected cell.
5. Press Enter, and Excel will display the sum of the row in the selected cell.