# How to Sum a Column in Excel (10 Easy Methods)

### Method 1 – Use Arithmetic Formula

Steps:

• Go to cell C12 and insert the formula.
`=C5+C6+C7+C8+C9+C10+C11`

We have entered the individual cells and added them to get the sum.

• Press ENTER to get the result.

Read More: How to Sum Columns in Excel (7 Methods)

### Method 2 – View the Sum of a Column in the Status Bar

Steps:

• Left-click on the column to highlight it.
• Go to the status bar and you will find the Sum of the column.

### Method 3 – Apply the AutoSum Feature

Steps:

• Go to cell C12 and navigate to the Home tab >> choose AutoSum from the Editing group >> pick ∑Sum.

The result will be displayed as shown below.

### Method 4 – Utilize the SUM Function

Steps:

• Go to cell C12 and insert the formula.
`=SUM(C5:C11)`

The syntax calculates the range of C5:C11 of column C.

• Press ENTER to get the output.

### Method 5 – Calculate the Sum of an Entire Column

Steps:

• Go to cell F5 and enter the formula.
`=SUM(C:C)`

C:C represents the C column, and the SUM function calculates the arithmetic sum.

• Press ENTER to get the output.

### Method 6 – Convert Data into Table

Steps:

• Select the entire range of the dataset.
• Go over the Insert tab >> choose Table from the Tables group.

The Create Table dialog window will open.

• Check the My table has headers box and click OK.

• Go to the Table Design tab and check the Total Row box.

You will get the total for the “Sales column.

### Method 7 – Sum a Column with Blank Cells

Steps:

• Go to cell C12 and enter the formula.
`=SUMIFS(C5:C11,B5:B11,"")`

This function checks the values in the sum_range of C5:C11 and tries to match criteria criteria1 which is ” “ (blank cells) from the criteria_range i.e. B5:B11 cells.

You will get the result after pressing ENTER.

### Method 8 – Sum a Column Based on Another Column

• Go to cell C12 and enter the following formula.
`=SUMIF(B5:B11,"John",C5:C11)`

This syntax checks “John in the criteria_range of B5:B11 and then takes the value from the sum_range and returns the sum.

### Method 9 – Find the Sum of a Column with Single Criteria

Steps:

• In cell C12, enter the following formula.
`=SUMIF(C5:C11,">1500",C5:C11)`

The function takes the sum_range i.e. C5:C11 and searches for the criteria of >1500 in the criteria_range of C5:C11.

### Method 10 – Calculate Sum with Multiple Criteria

Steps:

• In cell C12, enter the following formula.
`=SUMIFS(C5:C11,C5:C11,">1000",C5:C11,"<1500")`

The SUMIFS function takes the sum_range of C5:C11 and the criteria_range of C5:C11 for criteria1 (>1000) and criteria2 (<1500) and it will evaluate the sum.

## How to Sum Multiple Columns in Excel

Steps:

• In cell E12, enter the following
`=SUM(C5:E11)`

It will calculate the sum of three columns (C, D, and E).

• Press ENTER to get the output.