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

## How to Add a Total Row in Excel: A Step-by-Step Guide

Adding a total row in Excel allows you to quickly calculate the sum of a column of data. Follow these steps to add a totals row to your Excel spreadsheet.

#### Step 1: Select the Data You Want to Sum

• Click on the cell in the upper-left corner of the data you want to include in the sum.
• Hold down the "Shift" key and click on the cell in the lower-right corner of the data to select all cells in between.
• Alternatively, hold down the "Ctrl" key and click on each cell you want to select individually.

#### Step 2: Click the "Insert" Tab

• After selecting the data, go to the "Insert" tab at the top of the Excel window. This tab provides options for inserting various types of content into your spreadsheet.

#### Step 3: Click the "Total Row" Button

• Look for the "Tables" group of buttons on the "Insert" tab.
• Find and click the "Total Row" button.

#### Step 4: Enter the Formula

• A new row labeled "Total" will appear at the bottom of your data.
• Click on the cell at the far left of this new row.
• Enter the SUM formula in this cell. For example, if you want to sum cells in column A from row 1 to row 10, type: =SUM(A1:A10).

#### Step 5: Press Enter

• After typing the formula, press the "Enter" key on your keyboard.
• Excel will calculate the sum of the selected cells and display the result in the cell.