## Download Practice Workbook

**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.

**Read More:** **How to Sum Selected Cells in Excel (4 Easy Methods)**

**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.

**Read More:** **How to Sum Range of Cells in Row Using Excel VBA (6 Easy Methods)**

**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.

**Read More: ****How to Sum Rows in Excel (9 Easy Methods)**

**Similar Readings**

**How to Sum Colored Cells in Excel Without VBA (7 Ways)****Sum If a Cell Contains Text in Excel (6 Suitable Formulas)****How to Use VLOOKUP with SUM Function in Excel (6 Methods)****Sum Formula Shortcuts in Excel (3 Quick Ways)****How to Sum If Cell Contains Specific Text in Excel (6 Ways)**

**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

**which is**

*criteria1***” “**(

**blank cells**) from the

**i.e.**

*criteria_range***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

**and returns the**

*sum_range***sum**.

**Read More:** **How to Sum Filtered Cells in Excel (5 Suitable Ways)**

**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

**of**

*criteria_range***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

**of**

*criteria_range***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.

**Read More:** **Excel Sum If a Cell Contains Criteria (5 Examples)**

## Further Readings

**How to Sum Cells with Text and Numbers in Excel (2 Easy Ways)****Excel Sum Last 5 Values in Row (Formula + VBA Code)****How to Sum Multiple Rows and Columns in Excel****Sum to End of a Column in Excel (8 Handy Methods)****How to Sum Colored Cells in Excel (4 Ways)****Sum Cells in Excel: Continuous, Random, With Criteria, etc.**