# How to Sum a Column or Row of Excel Cells

Image Credit: Image courtesy of Microsoft

To help quickly add numbers, Excel displays a running sum of the currently selected cells in the status bar at the bottom of the window. To make use of this sum in a cell and automatically keep it up to date, add a formula using the AutoSum button. Starting with Office 2013, Excel also includes a Quick Analysis tool that adds sums for multiple rows or columns in one click.

## Step 1

Choose an adjacent cell to the data.
Image Credit: Image courtesy of Microsoft

Click in a cell next to the row or below the column of data you want to sum. For example, to add the values in A1 through C1, select cell D1.

## Step 2

Insert an AutoSum.
Image Credit: Image courtesy of Microsoft

Open the "Formulas" tab and click the "AutoSum" icon to automatically create a formula that sums the current row or column.

## Step 3

Image Credit: Image courtesy of Microsoft

Press "Enter" to accept the formula and display the sum in the cell. To later adjust the range of cells being to add, click the cell and change the beginning or ending cell number in the formula bar. Sums use formulas with the syntax "=SUM(A1:C1)" where "A1" represents the first cell and "C1" the last cell in the range.

## Step 1

Begin Quick Analysis.
Image Credit: Image courtesy of Microsoft

Highlight the entire field of data and click the "Quick Analysis" icon that appears near the corner of the selection.

## Step 2

Insert column sums.
Image Credit: Image courtesy of Microsoft

Switch to the "Totals" tab of Quick Analysis and click the horizontal "Sum" icon to add up each column in the selected area.

## Step 3

Insert row sums.
Image Credit: Image courtesy of Microsoft

Reopen the Quick Analysis menu without adjusting the selection. Open the "Totals" tab again and click the vertical "Sum" icon to add all rows of data.

## Step 4

Insert the grand total.
Image Credit: Image courtesy of Microsoft

Select the empty cell at the corner of the sums and add an AutoSum from the Formulas tab to create a grand total sum. To help the total stand out, adjust its font color or border on the Home tab.

### Tip

To add the contents of an entire row or column, no matter how many cells you later add to it, select a blank cell anywhere on the sheet and type a formula with the syntax "=SUM(A:A)" to add an entire column or "=SUM(1:1)" to add an entire row. Because this method updates the sum every time any cell in the target row or column changes, it can slow down Excel significantly if you have a large number of cells or if those cells depend on other complex formulas.

Add numbers by hand by typing them directly in a formula. For example, typing "=2+5" would display "7" in the cell.

Drag the edge of the cell containing the sum to move it to another location without affecting its contents.

### Warning

If AutoSum adds up values in the current column when you want it to add rows, press "Esc" to cancel, highlight the row of data you want to add instead of selecting a blank cell, and press "AutoSum" again.

references & resources
© 2021 Leaf Group Ltd. Leaf Group Media Manage Preferences